Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using late binding, and for some reason I'm getting lost trying to set a
reference to a Workbook object: Dim xlapp As Object Dim xlwkbs As Object Dim xlwkb As Object Set xlapp = CreateObject("Excel.Application") Set xlwkbs = xlapp.Workbooks so far so good (I think), but when I try to set a reference to a Workbook, I get a "Subscript out of range" error Set xlwkb = xlwkbs(strPathToFile) What I want to do is set the reference and then pass xlwkb to another function and do stuff like add worksheets. Do I need to set the reference differently? Thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
DSUM Basics | Excel Discussion (Misc queries) | |||
basics? | New Users to Excel | |||
Hi I'm New and need help with Excel Basics | Excel Discussion (Misc queries) | |||
Reference code in another workbook from a calling workbook | Excel Programming | |||
Excel VBA basics | Excel Programming |