Thread: Macro possible?
View Single Post
  #1  
Old June 5th, 2004, 08:57 AM
Nimit Mehta
external usenet poster
 
Posts: n/a
Default 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?