Save As

[petersen313]

Is there a way to do a Save As using VBS? I have a main program that uses VBS to open another excel file and make changes and I need to know if I can do a "Save As" to save the file with a different name (in this case, I want to save as with a new revised date so that we keep the old file).

Thanks.

 

[AlexM]

What do you mean under VBS?

 

[petersen313]

Sorry, I just meant that I am using Visual Basic.

 

[AlexM]

Workbook.SaveAs method saves workbook with different name. All methods available in VBA macro are available in Visual Basic too.