Posted to microsoft.public.excel.programming

keith

external usenet poster

Posts: 34

SaveAs syntax when using a variable

I need to save a file as read-only recommended. My file
name is stored in a variable, strSaveFile.

I can't get the SaveAs method to work correctly.

What I have:

exlSheet.SaveAs(strSaveFile,,,,True,,,,)
- True for read-only recommended.

This give me a compiler error.

What is the correct syntax?

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
Syntax for variable search	Tom Ogilvy	Excel Programming	3	August 6th 03 06:16 PM
Syntax for variable search	brym	Excel Programming	0	August 6th 03 05:41 PM
Syntax for variable search	brym	Excel Programming	2	August 6th 03 05:32 PM
Syntax for variable search	Don Guillett[_4_]	Excel Programming	0	August 6th 03 04:35 PM
saveas calling a variable	Douvid	Excel Programming	6	July 28th 03 08:46 AM

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

About Us

"It's about Microsoft Excel"

Menu

About Us