Hello,
Is it possible to copy and paste data from another workbook, without opening it? (i.e copying data from the 'source' and pasting it to the 'Master' file).
I'd like to copy data (Columns A:Z) from C:\Users\C2564\Desktop\Retail\RoL1.csv, Sheet 'RoL1' (The csv file is dynamic data so columns A:Z would cover everything).
to the Active Workbook, Sheet named 'RoL', Cell F1.
Thank you in advance for any help.
Is it possible to copy and paste data from another workbook, without opening it? (i.e copying data from the 'source' and pasting it to the 'Master' file).
I'd like to copy data (Columns A:Z) from C:\Users\C2564\Desktop\Retail\RoL1.csv, Sheet 'RoL1' (The csv file is dynamic data so columns A:Z would cover everything).
to the Active Workbook, Sheet named 'RoL', Cell F1.
Thank you in advance for any help.
Last edited: