View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
keith keith is offline
external usenet poster
 
Posts: 34
Default 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