topic Re: Excel VBO Run macro async is not working in Product Forum

Excel VBO Run macro async is not working

立晨姚 — Mon, 01 Nov 2021 02:51:18 GMT

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?

Re: Excel VBO Run macro async is not working

立晨姚 — Mon, 01 Nov 2021 03:10:19 GMT

The code for RunMacroAsync is:

Private Sub RunMacroAsync()
try
GetInstance(handleParam).Run(macroNameParam)
catch ex as exception
end try
End Sub

Re: Excel VBO Run macro async is not working

EVIPUTI — Mon, 01 Nov 2021 04:57:19 GMT

Just to check are all the Excel add-in/trust/macro settings are the same for both the machines ?

Re: Excel VBO Run macro async is not working

tiagorubio — Mon, 03 Jun 2024 18:54:58 GMT

Hi, can you share the full object that has this action?