Windows commands to save as excel sheet to html in to same location

R

Ravindra

New member
Joined
Apr 12, 2017
Messages
1
Reaction score
0
Points
0
I need windows command which can run in command prompt like as
Scenario:excel sheet named as "excel.xlsx" placed in my documents folder and i have to save as the excel.htm in the same location. i need to handle already exists dialog pop up as well.
Kindly help me out
 
[FONT=&quot]The following example show you how to save an Excel Workbook in a specific folder using SaveAs method:[/FONT]
Sub ExampleToSaveWorkbook()
Workbooks.Add
'Saving the Workbook
ActiveWorkbook.SaveAs "C:\WorkbookName.xls"
'OR
'ActiveWorkbook.SaveAs Filename:="C:\WorkbookName1.xls"
End Sub
 
You must log in or register to reply here.
Back
Top