View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Max Bialystock[_2_] Max Bialystock[_2_] is offline
external usenet poster
 
Posts: 31
Default for each doc in dir, copy data to excel

Hello there,

I have a directory full of word docs.

Each doc contains just name and address.

Each doc was used to print an address label for a parcel.

I need to get the name and address from each file, together with the date
the file was created.

This will provide a record in Excel of when each parcel was prepared for
dispatch.

I'm 99% sure this can be done with an Excel VBA routine, but I don't have
the skill to write it myself.

If anyone can help, Ill be most grateful indeed.

Max