Excel 2003 - VBA - OpenFileName popup

  • Thread starter Thread starter C Brandt
  • Start date Start date
C

C Brandt

I am have my users navigate to several workbooks for importing data. I would
like to work it so that they can do the navigation, store the path and
filename, then subsequently do the actual file manipulation.

I use the following code to access the fn & Path:

RTNFileName = Application.GetOpenFilename
Workbooks.Open (RTNFileName)

When the OPEN popup is presented, the header just says "Open". Is there a
way to change that so that it reminds the user what file they should be
accessing?

Any suggestions?

Craig
 
VBA's help is pretty nice on this one:

RTNFileName = application.getopenfilename(title:="what do you want here")

You may want to look at the other parms.
 
Back
Top