Im trying to write a Macro in a summary document so that I can open a specific browsing path, the user would select the file they want to use from the path, and then once they select the file, it would copy all the tabs in that document and move/copy them into the summary document.
So what I have so far is the below code
[VBA]Sub selectfile1()
Dim fNameAndPath As Variant
fNameAndPath = Application.GetOpenFilename(FileFilter:="Excel Files (*.XLS), *.XLS", Title:="Select File To Be Opened")
If fNameAndPath = False Then Exit Sub
Workbooks.Open Filename:=fNameAndPath
End Sub[/VBA]
But it doesn't open the specific path I want which is U:\ENG\Lab\Master Lab Files & Logs\Lab Electronic Test Requests\
How do I go about this?
I know how to opne up a specific file in a specific path and copy it into my workbook, but the specific file can vary and I want that option to be there.
Michael