Posted to microsoft.public.excel.programming

Wes_A[_2_] Wes_A[_2_] is offline

external usenet poster

Posts: 37

Saving a variable filename

Good day all
I am trying to write a MACRO in Excel 2007 running on XP to automate a file
save as follows:
I want to save the currently active worksheet as a new workbook *.xls or
*.xlsb where €œ*€ is a volatile filename contained in a cell on the currently
active worksheet, e.g. €œSeptember€, €œOctober€ €¦.
Can anyone help with the code?
Regards
Wes_A

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
Converting a Variable Filename to a Constant Filename	Magnivy	Excel Programming	2	August 15th 06 06:13 PM
Saving FileName	Harald Staff	Excel Programming	1	April 13th 05 08:50 PM
Saving with date in filename	Ben Allen	Excel Programming	3	April 26th 04 09:05 AM
Saving filename same as import filename	Matt	Excel Programming	4	February 24th 04 03:01 PM
Saving Cell value as filename	Kathy B	Excel Programming	1	July 24th 03 10:59 PM

All times are GMT +1. The time now is 02:30 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us