Excel - VBA - External File access

[C Brandt]

Here is a simple one:

I have a prepared workbook where I need to access another spreadsheet that
generally differs every day. What is the procedure to bring up the standard
file access window from within a spreadsheet using a VBA macro?

Thanks,

Craig

 

[Guest]

Try

Application.GetOpenFilename

Mike

 

[C Brandt]

Thanks Mike. Exactly what I was looking for.
Also thanks for the auto exec - Worked like a charm.