topic Re: Excel VBO - RunMacroFromTextfile in Product Forum

Excel VBO - RunMacroFromTextfile

paul.wright — Thu, 20 Nov 2025 13:26:34 GMT

So I am relatively new to Blueprism and I am currently developing a process whereby I am calling the Excel VBO - runmacrofromtextfile and no matter what I do to the inputs I cannot get it to work as I think I have done something wrong with the text file that contains the macro to run, and there being no examples of just HOW this should be structured, I can't get any further

I just literally dumped the Macro from within excel VBA into a straight textfile, but I am suspecting that it should be NAMED in a specific manner as the error I get is :-

Cannot run the macro 'wxyz'. The macro may not be available in this workbook

Re: Excel VBO - RunMacroFromTextfile

Tejaskumar_Darji — Tue, 25 Nov 2025 09:04:02 GMT

You need to have the macro inside the same workbook. Try to add the macro code in the same file and run.

Re: Excel VBO - RunMacroFromTextfile

SayeedBinAbdullah — Tue, 25 Nov 2025 09:14:42 GMT

Hi @paul.wright

As Tejas mentioned you need to have VBA code in the same workbook,

There are few more things to consider as below

1. All the setting related to Macros should be enabled in your excel application.

2. Excel file should be in .xlsm or .xltm format, only then you will be able to save VBA code in it (You can access the VBA project section by pressing Alt+F11 in you excel application-> And then write VBA code by inserting a Module).

Best Regards,
Sayeed Bin Abdullah

Re: Excel VBO - RunMacroFromTextfile

paul.wright — Tue, 25 Nov 2025 13:44:21 GMT

Hi Tej

So that negates the question I asked and I would just use RunMacro, as I am wanting to run a macro from a text file and not a file that contains the macro as the scenario in question is that the data file changes daily BUT needs the macro to perform some additional formatting before it is then worked

Paul

Re: Excel VBO - RunMacroFromTextfile

paul.wright — Tue, 25 Nov 2025 13:45:42 GMT

Hi Sayeed

See my reply to Tej above as I would have just used RunMacro if that is what I was trying to achieve but as explained, the source data file changes daily hence the use of an external text file to store the macro

Paul

Re: Excel VBO - RunMacroFromTextfile

SayeedBinAbdullah — Tue, 25 Nov 2025 14:18:46 GMT

Hey Paul,

Will the columns in the base excel be constant for every run?

If yes then you can create a template file in .xltm format and add macros in it,

Before using the RunMacro action you can copy the data into template file from the base file and then run the macro, then do Saveas to the template file and save it into source format (.xls or .xlsx).

Re: Excel VBO - RunMacroFromTextfile

Tejaskumar_Darji — Tue, 25 Nov 2025 14:22:12 GMT

Another way could be to store the macro in a new plain excel file instead of text file.

Then in BP open both files in a single handle or have a logic in macro to open the actual file and it will work that way too.

I understand the macro would not be present in the input file so having a macro template would be the right way to automate it.

Re: Excel VBO - RunMacroFromTextfile

naveed_raza — Fri, 28 Nov 2025 10:46:15 GMT

Maintain separate excel file and named it as your project name and save that excel file with .xlsm extension and store some where , where bots can access it and create 2 environment variable to store macro file path and macro name and utilize in your process.

You have to design your VBA code with proper error handling so that once macro is finished you can read the status of your macro easily.