Transfer data from an open workbook into an other open workbook

[plans]

Hello,
I want to transfer the value of cell A1 from worksheet called FromSheet which is part of an open workbook called FromWorkbook.csv into an other workbook's cell named ToRange which is in a worksheet called ToSheet which is part of an open workbook called ToWorkbook.xlsx.
Could you please advise of the code ?
Thank you.

[p24leclerc]

something like this should work although your ToWorkbook should probably be an XLSM workbook to hold the macro.
Or the macro could be in your Personnal.xlsb file.

Please Login or Register  to view this content.

[plans]

Thank you!