Macro Automation Issue

Hi,

Cannot run the macro ‘Macro1’. The macro may not be available in this workbook or all macros may be disabled.
I am continuously getting this issue, It is working successfully on my local but whenever i run it on server it gives this issue.

Note : (Tried all the add ons, settings from excel options )

Any help would be appreciate. Thanks in advance.

Regards,
Hemal

1 Like

Hi,
Open the macro window in your excel using send hot keys or type into activity and then write the macro in the macro window,

let us know if this helps,
Regards,
Pavan H

1 Like

Go to trusted settings and enable all macros in excel sheet.
Check Trust access to VBA process settings.
In Active x enable all settings

Regards
Vaneet

@pavanh003,

Unable to open macro through manually even via hot keys.

Regards,
Hemal

Hi ,
Is your file enableed with macro? if yes:
Try with alt+f8 to open the dialog box related to macro and then type the macro code that you want to have for the excel and then click on run,

Let us know if this helps,
Regards,
Pavan H

Can anyone please help me into ?

@pavanh003 thanks for your help, it’s already enabled.

I am running in local and it is throwing the dame error. Main thing is that error comes rarely! all of sudden!

Please give me some ideas for it! How would I resolved it

Regards,
Hemal

Hi,
Try using parallel activities, and this will solve the issue or you can use inside try catch or element exists where you can check for any error and then if error element exists you can do accordingly

Regards,
Pavan H