Write Range inside a Macro file(.xlsm)

Hi Friends,

I Have a .xlsm file(Macro file) and I have data in another excel file(.xlsx). I need to copy the range from .xlsx file and write into.xlsm file, can someone please help .

hi @RenukaRPA
Greeting for the day :slight_smile:

Follow the following steps:

  1. Read Range from the excel you want to read
  2. Open the xlsm format file in excel scope and write the range read from the xlsx format

The xlsm can only be read or used in uipath in the excel scope…

Hope this helps :slight_smile:

Good day :smiley:

Thanks for your reply Shubham, To write the range , I am not aware of the sheet , i will not be able to see the sheet Name in the macro file I have.

Do you mean it can change?

You can get a list of all the sheet names in the excel of the xlsm and use that to populate. Does this help?

Hi.

Read Range: Out of present range. (Exception from HRESULT: 0x8002000A (DISP_E_OVERFLOW))

I’m reading .xlsm file and we are getting above error using uipath read range activity.
if you have any solution of that can you please suggest.
i don’t want to specify range.
i want to read whole file. so please help

Please refer the following post

Hope this helps :slight_smile:

thanks buddy this is right. I have converted column type into text and it is worked. Uipath is read range activity worked. Thanks for sharing.

1 Like

Thank you, it did help :slight_smile:

1 Like