Move data from an excel to a macro enabled excel

So i have 2 files, the first one is a data file (normal excel format) and the second one is a macro excel file

I want to copy some of the data from the data file to one of the sheet in the macro excel file (because the macro needed the data from the data file to run)

is there a way to do this?
Already tried using read range, buat unfortunately read range can’t open excel macro files

Thanks in advance

Read Range to read data from simple excel
Then Write range to write that data into Macro Enabled File
Then U can use Execute Macro activity or hotkey for running macro

Thanks, it worked!


This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.