Create an Excel file, enter some data and save the file through VB scripting

    0
    15
    Spread the love
    • 1
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
      1
      Share

    Dim objexcel
    Set objExcel = createobject(“Excel.application”)
    objexcel.Visible = True
    objexcel.Workbooks.add
    objexcel.Cells(1, 1,1).Value = “Testing”
    objexcel.ActiveWorkbook.SaveAs(“d:exceltest.xls”)
    objexcel.Quit

    Don't miss out!
    Subscribe To Newsletter

    Receive top technical news, lesson ideas, travel tips and more!

    Invalid email address
    Give it a try. You can unsubscribe at any time.

    Spread the love
    • 1
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
    •  
      1
      Share

    LEAVE A REPLY

    Please enter your comment!
    Please enter your name here