Posted to microsoft.public.excel.programming

Steve[_40_] Steve[_40_] is offline

external usenet poster

Posts: 1

Adding a popup to specify a filename

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Adding date to filename?	teepee[_3_]	Excel Discussion (Misc queries)	5	April 15th 08 10:05 PM
Adding date for filename	Wins07	Excel Discussion (Misc queries)	2	July 31st 07 02:02 PM
Cell("filename") doesn't update to new filename when do save as.	Louis	Excel Worksheet Functions	2	March 22nd 07 07:27 PM
set filename to <filename-date on open	bob engler	Excel Worksheet Functions	2	July 13th 06 05:11 AM
"Why did we get here????" popup	jtwspoon	Excel Discussion (Misc queries)	3	February 4th 05 04:57 AM

All times are GMT +1. The time now is 05:23 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us