Hi all,
I am working on a script based on Ron de Bruin's "Copy every csv" original found here http://www.rondebruin.nl/win/s3/win022.htm
I am only importing 1 csv and I would like to get its Datemodified date and time and input it into the destination workbook in a specific cell.
I can do this if I hardwire the file path into my code but I cant get it to work using Rons code. I have tried using FileDateTime code and also a method using FileSystemObject. Both work separately when the path is fixed but not using Ron's file selection method.
Working sub code as follows, I've commented out the FileSystemObject method:-
Here's Rons amended code:-
Any help gratefully received,
Ian99
Bookmarks