Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,089
Default SaveAs syntax when using a variable

Keith

lose the brackets:

exlSheet.SaveAs strSaveFile, , , , True

Note though that Save and SaveAs relate to the workbook rather than a
worksheet. Your object gives the impression that you might be trying to
save a sheet. Just something to bear in mind.

Regards

Trevor


"Keith" wrote in message
...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

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 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"