Setting OnAction Property Fails
in [Programming]
|
From: "Josh Sale" <jsale@tril dot on 30 Aug 2005 15:54 I have an add-in that works just fine when there is a single instance of it running on a particular machine. However, if two copies get launched at essentially the same time on the same machine, I get the following error: Method 'OnAction' of object '_CommandBarButton' failed. The runtime error number is 80004005. The failing line of code looks like this: Dim cmdButton As CommandBarButton cmdButton.OnAction = "SomeMacroName" Again, the assignment statement and the resulting toolbar button work just fine when a single instance of Excel and the add-in is running ... the error only happens when two copies are started at the same time. Any thoughts? Do multiple copies of Excel share something that's causing this problem? BTW, am running XL2003. TIA, josh
From: Jim Thomlinson on 30 Aug 2005 16:59 My question is how are you getting two instances of the addin running on one machine concurrently? Solve that and the problems go away... Is the addin installed through code? -- HTH... Jim Thomlinson "Josh Sale" wrote: > I have an add-in that works just fine when there is a single instance of it > running on a particular machine. > > However, if two copies get launched at essentially the same time on the same > machine, I get the following error: > > Method 'OnAction' of object '_CommandBarButton' failed. > > The runtime error number is 80004005. The failing line of code looks like > this: > > Dim cmdButton As CommandBarButton > > cmdButton.OnAction = "SomeMacroName" > > Again, the assignment statement and the resulting toolbar button work just > fine when a single instance of Excel and the add-in is running ... the error > only happens when two copies are started at the same time. > > Any thoughts? > > Do multiple copies of Excel share something that's causing this problem? > > BTW, am running XL2003. > > TIA, > > josh > > >
From: "Josh Sale" <jsale@tril dot on 30 Aug 2005 18:00 Jim, We're actually running multiple instances of Excel and the add-in intentionally. We have a non-Excel process runs on a server and that reads messages off of a queue. Depending on the content of each message this process spawns off a copy of Excel with command line arguments that are based on the message content. So we want to make this work. The add-in isn't added by code. josh "Jim Thomlinson" <jamest(a)tcgiRe-Move-This.com> wrote in message news:E8DB4F74-2391-4B78-A941-A873F980D20F(a)microsoft.com... > My question is how are you getting two instances of the addin running on > one > machine concurrently? Solve that and the problems go away... Is the addin > installed through code? > -- > HTH... > > Jim Thomlinson > > > "Josh Sale" wrote: > >> I have an add-in that works just fine when there is a single instance of >> it >> running on a particular machine. >> >> However, if two copies get launched at essentially the same time on the >> same >> machine, I get the following error: >> >> Method 'OnAction' of object '_CommandBarButton' failed. >> >> The runtime error number is 80004005. The failing line of code looks >> like >> this: >> >> Dim cmdButton As CommandBarButton >> >> cmdButton.OnAction = "SomeMacroName" >> >> Again, the assignment statement and the resulting toolbar button work >> just >> fine when a single instance of Excel and the add-in is running ... the >> error >> only happens when two copies are started at the same time. >> >> Any thoughts? >> >> Do multiple copies of Excel share something that's causing this problem? >> >> BTW, am running XL2003. >> >> TIA, >> >> josh >> >> >>
From: Jim Thomlinson on 30 Aug 2005 19:10 Multiple instances of excel running should not (to the best of my knowledge) cause any difficulty. Each one resides in it's own world and does not interact with other instances. In any one instance of Excel do you have the addin running more than once (I might be a little slow on the uptake but I could not determine that from your post)? -- HTH... Jim Thomlinson "Josh Sale" wrote: > Jim, > > We're actually running multiple instances of Excel and the add-in > intentionally. We have a non-Excel process runs on a server and that reads > messages off of a queue. Depending on the content of each message this > process spawns off a copy of Excel with command line arguments that are > based on the message content. > > So we want to make this work. > > The add-in isn't added by code. > > josh > > > > "Jim Thomlinson" <jamest(a)tcgiRe-Move-This.com> wrote in message > news:E8DB4F74-2391-4B78-A941-A873F980D20F(a)microsoft.com... > > My question is how are you getting two instances of the addin running on > > one > > machine concurrently? Solve that and the problems go away... Is the addin > > installed through code? > > -- > > HTH... > > > > Jim Thomlinson > > > > > > "Josh Sale" wrote: > > > >> I have an add-in that works just fine when there is a single instance of > >> it > >> running on a particular machine. > >> > >> However, if two copies get launched at essentially the same time on the > >> same > >> machine, I get the following error: > >> > >> Method 'OnAction' of object '_CommandBarButton' failed. > >> > >> The runtime error number is 80004005. The failing line of code looks > >> like > >> this: > >> > >> Dim cmdButton As CommandBarButton > >> > >> cmdButton.OnAction = "SomeMacroName" > >> > >> Again, the assignment statement and the resulting toolbar button work > >> just > >> fine when a single instance of Excel and the add-in is running ... the > >> error > >> only happens when two copies are started at the same time. > >> > >> Any thoughts? > >> > >> Do multiple copies of Excel share something that's causing this problem? > >> > >> BTW, am running XL2003. > >> > >> TIA, > >> > >> josh > >> > >> > >> > > >
From: "Josh Sale" <jsale@tril dot on 30 Aug 2005 20:11 No ... a single copy of the add-in in each instance of Excel. At startup, the add-in creates a few toolbars and puts a number of buttons on each one. So there is a period where maybe 20 or 30 toolbar buttons, shortcut menu's, etc have their OnAction property set. And this is where it blows it brains out. josh "Jim Thomlinson" <jamest(a)tcgiRe-Move-This.com> wrote in message news:F1B4E722-B033-4AC3-B4F1-5879473937CC(a)microsoft.com... > Multiple instances of excel running should not (to the best of my > knowledge) > cause any difficulty. Each one resides in it's own world and does not > interact with other instances. In any one instance of Excel do you have > the > addin running more than once (I might be a little slow on the uptake but I > could not determine that from your post)? > -- > HTH... > > Jim Thomlinson > > > "Josh Sale" wrote: > >> Jim, >> >> We're actually running multiple instances of Excel and the add-in >> intentionally. We have a non-Excel process runs on a server and that >> reads >> messages off of a queue. Depending on the content of each message this >> process spawns off a copy of Excel with command line arguments that are >> based on the message content. >> >> So we want to make this work. >> >> The add-in isn't added by code. >> >> josh >> >> >> >> "Jim Thomlinson" <jamest(a)tcgiRe-Move-This.com> wrote in message >> news:E8DB4F74-2391-4B78-A941-A873F980D20F(a)microsoft.com... >> > My question is how are you getting two instances of the addin running >> > on >> > one >> > machine concurrently? Solve that and the problems go away... Is the >> > addin >> > installed through code? >> > -- >> > HTH... >> > >> > Jim Thomlinson >> > >> > >> > "Josh Sale" wrote: >> > >> >> I have an add-in that works just fine when there is a single instance >> >> of >> >> it >> >> running on a particular machine. >> >> >> >> However, if two copies get launched at essentially the same time on >> >> the >> >> same >> >> machine, I get the following error: >> >> >> >> Method 'OnAction' of object '_CommandBarButton' failed. >> >> >> >> The runtime error number is 80004005. The failing line of code looks >> >> like >> >> this: >> >> >> >> Dim cmdButton As CommandBarButton >> >> >> >> cmdButton.OnAction = "SomeMacroName" >> >> >> >> Again, the assignment statement and the resulting toolbar button work >> >> just >> >> fine when a single instance of Excel and the add-in is running ... the >> >> error >> >> only happens when two copies are started at the same time. >> >> >> >> Any thoughts? >> >> >> >> Do multiple copies of Excel share something that's causing this >> >> problem? >> >> >> >> BTW, am running XL2003. >> >> >> >> TIA, >> >> >> >> josh >> >> >> >> >> >> >> >> >>
|
Next
|
Last
Pages: 1 2 3 Prev: I want to use a oleDragDrop in an Excel VBA Userform Next: Macro with Essbase Add-in |