I am working on BPC (Business Planning and Consolidation) I have opened one report (Excel file) from server but I can not use normal excel activities in BOT Program as this excel file is not saved on my Laptop but i am accessing it from server.
I want to copy data from the excel file fetching from server and paste data in new excel file. How I can use Copy sheet or any other excel Activity as this excel file not saved on my Laptop and in COPY SHEET activity I have to give path of excel file.
Regards,
Lavdeep Singh