View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
M M is offline
external usenet poster
 
Posts: 18
Default Count Worksheets - Late Binding

Using the code:

Dim oApp as Object
intCount as Integer

Set oApp = CreateObject("Excel.Application")

oApp.Workbooks.Open("C:\Test.xls")

to open a .xls with late binding, what would I use to
count the worksheets?

And I'm having to use late binding to avoid reference
issues and cannot use early binding. (Thanks to our IT
Dept.)

Thanks

M