Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX error - multiple workbooks appearing in vbproject
Dear All,
I'm running code and I am getting instances when I get ActiveX - can't create object. When I end procedure I get multiple workbook objects in my vbProject (named the sheet the procedure was working on). I think it is to do with the fact I am using the object name of a sheet to pass it to a function which finds the usedrange. Please can anyone put some light into why this might be happening? Thanks Mac |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
ActiveX error - multiple workbooks appearing in vbproject
It would be helpful if you posted the relevant portions of your code
and indicate which line of code is highlighted when the error occurs. In and of itself, passing a Worksheet type object around to various procedures shouldn't cause any problems. Cordially, Chip Pearson Microsoft Most Valuable Professional Excel Product Group Pearson Software Consulting, LLC www.cpearson.com (email on web site) On Sun, 19 Oct 2008 09:37:19 -0700 (PDT), wrote: Dear All, I'm running code and I am getting instances when I get ActiveX - can't create object. When I end procedure I get multiple workbook objects in my vbProject (named the sheet the procedure was working on). I think it is to do with the fact I am using the object name of a sheet to pass it to a function which finds the usedrange. Please can anyone put some light into why this might be happening? Thanks Mac |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error when multiple macro driven workbooks open | Excel Programming | |||
Countif error using multiple workbooks | Excel Discussion (Misc queries) | |||
Trap error in: ThisWorkbook.VBProject.References.Item(i).FullPath | Excel Programming | |||
How do I stop the activeX screen appearing when I open excel | Excel Discussion (Misc queries) | |||
Error 50290: Error writing to Worksheet while using an ActiveX Control | Excel Programming |