| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run-time error 9 when running add-in
Thanks Nick.
NickHK wrote: Rob, Dave's point was that your code probably does not need/want to interact with add-in, because by their nature, they are different to a "normal" spread sheet. For example, with an addin I have: ?workbooks("pdfmaker.xla").name PDFMaker.xla ?workbooks("pdfmaker.xla").windows(1).Visible error "SubScript out of Range" So skip addins (including your own) in your code. When run from Personal.xls, you did not have any add-ins installed and consequently never raised this error. Moving the code to an add-in, created the error. NickHK "RobH" wrote in message ps.com... Ignoring the add in wouldn't help, because I want the add in to be run. My confusion is that the code works perfectly when run from PERSONAL.XLS (where we don't want it to be), but falls over when run from the add-in (where we do want it to be). Rob -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Run time error 1004 When running in 2003 | Excel Programming | |||
| Run time error 1004 When running in 2003 | Excel Discussion (Misc queries) | |||
| Run Time error '1004' when running Calculation method | Excel Programming | |||
| Run-time error '1004' running to excel objects at once | Excel Programming | |||
Hybrid Mode
