Excel.Application

[jode]

Please help me the following code does not work for me and I have been out of coding for a while and getting very frustrated

Dim appExcel As Excel.Application
Dim wbk As Excel.Workbook
Dim wks As Excel.Worksheet

If I create a new object then I cannot work out how to reference the workbook / worksheets....

I am sure it is something as simple as a missing reference

 

[Remou]

It probably is.

Go to Tools->References and make sure

Microsoft Excel x.x Object Library

is checked.

 

[PHV]

A starting point:
Set appExcel = CreateObject("Excel.Application")
Set wbk = appExcel.Workbooks.Open("\path\to\spreadsheet.xls")
Set wks = appExcel.ActiveSheet

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886