Posted to microsoft.public.excel.programming

Mike D[_3_] Mike D[_3_] is offline

external usenet poster

Posts: 5

Excel Filename prgramatically

I have a line of code:

strThisFileName = "MY Excel FileName.xls"

How do I set my variable to the current excel filename?

strThisFileName = Workbooks.??

Thanks
Mike

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
Excel adds a 1 to the end of the filename.	pcgurudude	Excel Discussion (Misc queries)	4	July 15th 08 02:16 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
Excel puts a 1 at the end of my filename	hammfamily	Excel Discussion (Misc queries)	1	March 9th 05 12:47 AM
Saving filename same as import filename	Matt	Excel Programming	4	February 24th 04 03:01 PM

All times are GMT +1. The time now is 08:46 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us