Not path but name, not workbook but Windows
![]()
Sub a() Dim Entry As String Dim Filepath As String Filname = "Cartel1.xlsx" 'Range("D6").Value Entry = "Sheet1" 'Range("D8").Value Windows(Filname).Activate Worksheets(Entry).Activate End Sub
Not path but name, not workbook but Windows
![]()
Sub a() Dim Entry As String Dim Filepath As String Filname = "Cartel1.xlsx" 'Range("D6").Value Entry = "Sheet1" 'Range("D8").Value Windows(Filname).Activate Worksheets(Entry).Activate End Sub
If solved remember to mark Thread as solved
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks