Posted to microsoft.public.excel.programming

Matt G[_2_] Matt G[_2_] is offline

external usenet poster

Posts: 14

Auto file naming with macro

Hi,

I have a macro that rearranges the info in a file the way I want it. I
would to be able to save the updated file automatically using a static
beginning then adding a name part from within the worksheet. I don't want to
"SaveAs"; I want to overwrite the original file

For example: I want the file named "Account changes for 0XXX" where XXX
would be Left(C2, 3)

Any help is appreciated

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
Auto Naming Worksheets	Will Cendrowski[_2_]	Excel Discussion (Misc queries)	4	October 23rd 09 02:03 PM
Auto file naming	Jacquesvv	Excel Discussion (Misc queries)	1	June 23rd 09 02:57 PM
file naming during auto-saveas	SJW_OST[_2_]	Excel Programming	3	July 6th 08 06:07 PM
Check cells for 'Auto Save As' file naming	Shinka	Excel Programming	3	October 19th 05 04:16 PM
Macro to call a file that has a auto open macro in the file itself	[email protected]	Excel Programming	1	August 5th 05 06:39 AM

All times are GMT +1. The time now is 09:21 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us