ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Running an add-in recursively on embedded files (https://www.excelbanter.com/excel-programming/364602-running-add-recursively-embedded-files.html)

akullen[_2_]

Running an add-in recursively on embedded files
 

Hello,

I have built a VBA add-in that I want to run recursively on all
embedded files it finds.

What it does now when it finds an embedded file it activates it and
executes the CommandBarButton that the add-in is connected to.

It works one level down but if it goes down two levels the execute
raises error -2147467259(80004005)

I am not an expert on this so if I am doing something really strange
here, do not hesitate to tell me.

Best Regards
Anders.


--
akullen
------------------------------------------------------------------------
akullen's Profile: http://www.excelforum.com/member.php...o&userid=32513
View this thread: http://www.excelforum.com/showthread...hreadid=552956


akullen[_3_]

Running an add-in recursively on embedded files
 

Hello,

As I said, I am not an expert on this which I proved by using the
CommandBarButton object instead of just calling the sub. I happy I
figured that out by myself.

BR
Anders.


--
akullen
------------------------------------------------------------------------
akullen's Profile: http://www.excelforum.com/member.php...o&userid=32513
View this thread: http://www.excelforum.com/showthread...hreadid=552956



All times are GMT +1. The time now is 03:11 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com