Word Pages to Excel Sheets Macro

[aequitas1903]

Hi Guys,

I am working on word documents that has financial numbers on them. I am copying word pages to excel to calculate the numbers by using formulas and etc. I will cut to the chase; is there a way or a macro to insert into an excel template workbook(.xltx) when we open the template there will be a command button to select the word document (which we want to copy its pages) to excel sheets. When a new page begins a new sheet will be created and the page will be pasted on the new sheet.

It is not important if it has to have a command button to select the word document it is ok to run the macro and select the word document and it does not has to populate sheets according to length of word document (I can create lost of free sheets on the template)

The main idea is to gain the time I spend on copying the word document to excel sheets. Some documents can be very long (100 pages). I am using MS Office 2007.

I triend to export data but excel does not allow me to select word documents.

I appreciate any help.
Thanks to everyone at least who reads this

 

[aequitas1903]

Hello everyone is there anyone who has an idea ?

Thank you

 

[s hal]

Are you doing the word document as the final product or the front end of your process? I've used a named range and mail merge with much success for this sort of excel to word thing before. Perhaps that would work for you as well? (I know it sounds like a weird way to go, but its pretty amazing sometimes too)

 

[aequitas1903]

front end. word document is the starting point of the work. The problem is I am not exporting from data to excel, I am trying to export data from word to excel. Word pages to excel sheets. But every word document is different from the last one.

 

[aequitas1903]

Any ideas ?

 

[patel45]

I think it's possible to use formulas for simple calculations also in Word tables