You can reference an add-in via the Workbooks collection, even though
add-ins aren't included in the enumeration. In other words, you won't see
the add-in in
For Each WB In Workbook
' whatever
Next WB
But you can access it with code like the following:
Workbooks("CellView.xla").Worksheets(1).Range("A1" ).Value = 123
Note that if you change cell values in an add-in, or make any other changes,
you are NOT prompted to Save when the add-in is closed, and changes will NOT
be saved unless you do a Save operation.
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
(email address is on the web site)
"scotty" wrote in message
ups.com...
I load an addin from the command line (debugging in visual studio this
is the only option)
excel.exe somename.xla...etc
Now, the Applications.Addins collection will NOT have the addin I just
started from the command line.
Anyone know how to gain a handle to it?
it isnt a workbook, it isnt a worksheet etc.