I have a sheet with 6 file paths (A1 to A6)
I am trying to write a macro that will look on A1 the file path and directly copy the file information and past in a new sheet on my excel. Then repeat the process for the other 5 path/files.
I would prefer to avoid the open file, copy and close file.
Also the files can be in *.csv, *.txt or *.xls extension
If you could point me in right direction I would appreciate.
Thank you
I am trying to write a macro that will look on A1 the file path and directly copy the file information and past in a new sheet on my excel. Then repeat the process for the other 5 path/files.
I would prefer to avoid the open file, copy and close file.
Also the files can be in *.csv, *.txt or *.xls extension
If you could point me in right direction I would appreciate.
Thank you