PDA

View Full Version : VBA to extract Data from Word to Excel



AmmuGopi
10-23-2013, 07:16 AM
Hi Expert,

I am trying to find a macro in excel which will extract or copy the information in a particular word document and paste the same into excel sheet and rename the sheet as per the file name and continue the activity till all the data of documents in the folder is copied or extracted into one excel file.

Thanks in advance for the help.

Regards,
AmarG

patel
10-23-2013, 09:16 AM
can you attach the word doc, indicate informations to copy, attach the excel file wth informations pasted ?