Find File Window - Workbook when its not in same folder location

[Grimm127]

Hi All,

I have a question. I have the following code saved in my macro:


'Open ITEM MASTER SKU
Workbooks.Open Filename:= _
"R:\Shared\TEAM\VMI FILES\ITEM Master SKU (NEW).xlsx", ReadOnly:=True, Notify:=False

However, I would like to add in some code that will open a find file window if the above code doesn't locate the file.

Reason is that I sometimes take the files with me and then I save them on another computer and I don't want to rewrite the above code everytime I switch it up.

Can you help me out?
Thanks!

 

[JoeMo]

Take a look at the Application.GetOpenFilename Method in VBA Help. Will allow you to select the file(s) you want to reference in your code. Doesn't actually open the file(s), but returns the name and can include the path to the folder where the file(s) resides.

 

[Grimm127]

I "F1" in the help and past in and I get an error. I even type it out and still no luck.

 

[JoeMo]

I "F1" in the help and past in and I get an error. I even type it out and still no luck.

Open the VBE window. Type "getopenfilename" (without the quote marks) in the search box (upper right corner) and press Enter.

 

[Grimm127]

Did it exactly like you said and still I get "Sorry, there are no results for getopenfilename" Try rephrasing your query.

 

[JoeMo]

Did it exactly like you said and still I get "Sorry, there are no results for getopenfilename" Try rephrasing your query.

What version of Excel are you using? As an alternative google "Excel VBA GetOpenFileName".