Macro possible?
I have a folder with about 1000 workbooks.
All contain data of conference customers.
All customers have unique account number.
Account Date TIme Country Rate Minutes
34254 26-Jun 4:45 PM USA 2.5 56
I want to have a macro that will open workbook "34256.xls"
and paste the date,time,country,rate and minutes as above
in the empty cells available, save "34256.xls" and exit
the file.
Is that possible?
|