Results 1 to 2 of 2

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

  1. #1

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



    Register for a FREE account, and/
    or Log in to avoid these ads!

    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

  2. #2
    Acolyte bobjglover@gmail.com's Avatar
    Join Date
    Aug 2015
    Posts
    57
    Articles
    0
    Excel Version
    1901
    The following example show you how to save an Excel Workbook in a specific folder using SaveAs method:
    Sub ExampleToSaveWorkbook()
    Workbooks.Add
    'Saving the Workbook
    ActiveWorkbook.SaveAs "C:\WorkbookName.xls"
    'OR
    'ActiveWorkbook.SaveAs Filename:="C:\WorkbookName1.xls"
    End Sub

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •