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