Word VBA to Open Excel File

[firefly2k8]

Hi All,

I want to open an excel file from word, using word vba. I want to send some data to and from as well.

Tried this, but get "user defined object not defined"

Please Login or Register  to view this content.

Any ideas?

[abousetta]

Hi,

I don't have much experience opening excel from word but try this:

Please Login or Register  to view this content.

Good luck.

abousetta

[firefly2k8]

Hi, thanks for your response. It didn't quite work, but I got it going with the following:

Please Login or Register  to view this content.

I would now like to send data to excel, have that data update the sheet, then return the result to word. Any ideas!?

[romperstomper]

What data and where to?
FYI, your original code would work fine if you set a reference (via Tools-References in the VB Editor) to the 'Microsoft Excel Object 11.0 Library'. The 11 is the version number, so 10 for Office XP, 12 for Office 2007, 14 for Office 2010.

[firefly2k8]

I want to take data from 16 text boxes in the Word doc, paste it to the named range "weights" in the first sheet of the excel workbook called "summary", this happens to be cells B31:B47. Then I want to take range C52:I69 and paste it back into word.

I tried getting word to run an excel macro with:

Please Login or Register  to view this content.

but it doesn't like this.

[romperstomper]

Run is a method of the application, not workbook, so you need:

Please Login or Register  to view this content.

For the rest it would be useful to see sample documents. (Word VBA is not my thing, but I can probably cobble something together with a sample)