Wednesday, 16 September 2015

HOW TO OPEN AN EXCEL SPREADSHEET



Steps:

Declare the variables
Create the object using excel application
Assign the excel file to the variable by using workbooks & open function

Ans:
Set objExcel = CreateObject("Excel.Application")
Set objWorkbook = objExcel.Workbooks.Open("C:\Scripts\New_users.xls")


SUBSCRIBE YOUTUBE CHANNEL FOR LATEST VIDEOS  

No comments:

Post a Comment