Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Syntax for variable search | Excel Programming | |||
Syntax for variable search | Excel Programming | |||
Syntax for variable search | Excel Programming | |||
Syntax for variable search | Excel Programming | |||
saveas calling a variable | Excel Programming |