In windows, you can right click a file and open its location. It will highlight the file. Is there a way to do this in excel with a hyperlink or a macro?
In windows, you can right click a file and open its location. It will highlight the file. Is there a way to do this in excel with a hyperlink or a macro?
This what you want?
Sub abc() Dim fd As FileDialog Dim sFileFullName As String Set fd = Application.FileDialog(msoFileDialogFilePicker) With fd .ButtonName = "Select" .AllowMultiSelect = False .Title = "Choose Transactions file to import" .InitialView = msoFileDialogViewDetails .Show sFileFullName = .SelectedItems(1) End With MsgBox sFileFullName Set fd = Nothing End Sub
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks