Excel VBO Run macro async is not working
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-11-21 02:51 AM
Below is the stage code :
macroNameParam = MacroName
handleParam = Handle 'instance number
threadObject= New System.Threading.Thread(AddressOf RunMacroAsync)
threadObject.Start()
It works for my former employer. But it is not working for my currently employer. It just run over this stage and Macro did not kick off and no error show up.
Any idea what could be the issue?
macroNameParam = MacroName
handleParam = Handle 'instance number
threadObject= New System.Threading.Thread(AddressOf RunMacroAsync)
threadObject.Start()
It works for my former employer. But it is not working for my currently employer. It just run over this stage and Macro did not kick off and no error show up.
Any idea what could be the issue?
3 REPLIES 3
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-11-21 03:10 AM
The code for RunMacroAsync is:
Private Sub RunMacroAsync()
try
GetInstance(handleParam).Run(macroNameParam)
catch ex as exception
end try
End Sub
Private Sub RunMacroAsync()
try
GetInstance(handleParam).Run(macroNameParam)
catch ex as exception
end try
End Sub
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
01-11-21 04:57 AM
Just to check are all the Excel add-in/trust/macro settings are the same for both the machines ?
------------------------------
Vipul Tiwari
Senior Process Simplification Developer
Amazon
------------------------------
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Email to a Friend
- Report Inappropriate Content
03-06-24 07:54 PM
Hi, can you share the full object that has this action?
