Change directory before File-Open
H all,
I have list of files whose file names changes everyday, like :
filename_mmddyy.xls where they reside in a directory structure like:
\\server\root\YYYY\mm-yyyy\
I would like to direct Excel to go the specified directory and bring up the
File-Open dialog box and let the user select the file then allow the code to
continue after the right file is opened.
I am trying to eliminate the need for having the users to navigate to the
directory and select the file. I would like to navigate there first and
then let the users select the file. I tried using the ChDir command first
and then use the [Application.GetOpenFilename] command but it didnt go to
the right directory first. Can you share some suggestions? Thanks in
advance.
Ben
|