View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Kenny Kenny is offline
external usenet poster
 
Posts: 27
Default Copy data from one workbook to another of same name

I'm a bit desperate, so yes.... At around 100 files, and
the close and save being automated (?), shouldn't take too
long, yes?

Anyway, I'm all ears if you can point me in the direction
to start....

TIA!


-----Original Message-----
This can definitely be done in a macro if you are willing

to start the
macro and then find the destination file in an open

prompt...the macro
would then open that file...put in the 50 rows (how many
columns?)...and then close and save the file.

.