Posted to microsoft.public.excel.programming

Greg H.[_3_] Greg H.[_3_] is offline

external usenet poster

Posts: 30

Format Date in Save AS function

I am receiving a strange error message when trying to run the below script:

ActiveWorkbook.SaveAS "c:\Daily Reports for DP\NPP_" & Format(Date,
"mmddyy")

The error i get highlights "Format" and a msg box says:

Compile Error:

Wrong number of arguments or incalid property assignment

Any ideas as to what is wrong?

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
SAVE AS CSV, KEEP DATE FORMAT	clau	Excel Worksheet Functions	3	April 3rd 23 06:42 PM
Date format won't save...?	Erin[_2_]	Excel Worksheet Functions	4	December 18th 08 02:48 PM
date format changes when I save to CSV via a macro	brawlsadford	Excel Programming	1	May 16th 07 02:06 PM
date format changes when I save to CSV via a macro	John Taylor	Excel Discussion (Misc queries)	4	May 16th 07 01:44 PM
Save Location - Date Format	Ravi Sandhu	Excel Programming	2	February 12th 04 03:37 PM

All times are GMT +1. The time now is 07:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us