Mega Code Archive

 

Categories / VisualBasic Script / Excel

 

Save as the active workbook

Sub saveAsDemo()    ActiveWorkbook.SaveAs FileName:="c:\MyFile.xls" End Sub