What I am trying to do is to open an Excel file and process each worksheet in that file. I have declared both a Excel.Workbook and a Excel.Worksheet variable.
Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlSheet As Excel.Worksheet
I thought I might be able to cycle through using a For Each loop such as:
For Each xlsheet In xlBook
When I execute this I get an error that the object does not support this method.