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
Dave Peterson - 19 Nov 2007 02:06 GMT
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.
> 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
[quoted text clipped - 12 lines]
>
> Craig

Signature
Dave Peterson