OleObjects very urgent issue
Hello,
I have inserted an ActiveX in the Activesheet and so far I was able to reference its Object property. For example MsgBox TypeName(g.object) will return "CircleGauge1" , the name and index of the the control . g is defined as OleObject Strangely and suddenly, the same command returns "RunTime1004, unable to get the object property of the OleObjects class" although the ActiveX in properly registred What is more strange is that from time to time it starts to work again but I could not figure out the logic I am really stucked and your help will be very appreciated Avi |
All times are GMT +1. The time now is 06:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com