Adding a popup to specify a filename
Dim fName as String
Chdrive "C"
Chdir "C:\Myfolder"
fname = Application.GetOpenFileName()
If ucase(fname) < "FALSE" then
Workbooks.Open fname
End if
See excel vba help on GetOpenFileName
for information on arguments you may use.
--
Regards,
Tom Ogilvy
Steve wrote in message
...
I have a macro that reads in a file. The file's name
changes every day when the date is appended. How can I
change my macro so that instead of always calling
MyFile.xls it prompts the user to type in the filename? I
can't make it call in MyFile_with_today's_date.xls because
sometimes I have to run the macro on old files.
Thanks
|