Transfer data from another excel file without open it

Hi!

I have a code that transfers data from the excel file Register Data 2022.xlsm to Excel file KPI 2022.xlsm. The macro is executed from the Excel file KPI 2022.xlsm but as it is now, it needs to have the file "Register Data 2022.xlsm" opened.

Is there somebody that can edit my existing code without the need to open the file Register Data 2022.xlsm Excel file? You must know that this file is always 24-7 opened in another pc in the production line. As it works now, I always open it in read mode and then I transfer the data to my KPI 2022.xlsm excel file.

The Register Data 2022.xlsm file is in F:\productionlines\T1\Data

Please Login or Register  to view this content.

In case you need more info, I will be glad to share it with you. Thanks!

Originally Posted by Richard Buttrey

Why do you have a reluctance to open the file?

If I have to keep doing it I will just do it, it is not a big problem :D

But of course, I just was wondering if there is a faster way to transfer the data by eluding to open the file that has the data...