• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 137
  • Last Modified:

Opening an Excel file programatically to get cell contents

I would like to open an excel file and get the sheet content and cell contents so I can assign it to a variable for manupulation.  

How is it done.

Thank you very much,

1 Solution
You can use OLE , by setting refernce to Microsoft Excel 8.0 Library or
Microsoft Excel 9.0 Library

dim oWorkBook as Excel.WorkBook
dim oWorkSheet as Excel.WorkSheet

set oWorkBook = GetObject ( , "You path of file.xls" )

set oWorkSheet = oWorkBook.WorkSheets(1)

Hope that will help You.

Bye - bye ...

Featured Post

Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now