Running Word Macros from Excel

**shinobi** · 11-13-2011, 09:56 AM

Hello,

I have a set of sub procedures that run in Excel, and the last one opens a certain document in Word. I would like to run and add a few more sub procedures that are already stored in the Word document to the main Excel procedure, as in all Excel macros are run first, then the Word document is open and then the Word macro is run.

I have tried playing around with the following:

Please Login or Register  to view this content.

It goes smoothly as far as opening the Word document but then I get Object Required error

Is there something that I'm missing in the code?

Regards,
shinobi

**TMS** · 11-13-2011, 01:31 PM

You have objWord and WordApp ... I'm guessing they're meant to be the same?

Regards

**Dirigo** · 11-13-2011, 02:01 PM

Try

Please Login or Register  to view this content.

**shinobi** · 11-13-2011, 02:06 PM

Hi TMShucks,

Yes you are correct, thanks for pointing it out. It worked when I changed the name. However, I run into some problems later in Word (string longer than 255 characters - the macro there was supposed to start mail merge). I wanted to have one macro do everything but will have to split it into one Excel and one Word macro. Anyway, thanks for your help.

**TMS** · 11-13-2011, 02:08 PM

You're welcome. Thanks for the rep.

Can't you run it all from Excel once you've created the word object?

Regards

**shinobi** · 11-13-2011, 02:17 PM

I googled it and this is what Microsoft says about that:

"When you use Microsoft Visual Basic for Applications code to perform a mail merge with external data, you may receive the following error message:

Run-time error '9105'
String longer than 255 characters

This problem occurs because Word cannot create a connection string that is longer than 255 characters.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section"

I think that's exactly my case, I was trying to do mail merge with external data (data from the Excel file that my initial macros run in and then open the Word document)

Both Excel and Word macros seem to work ok on their own, it is just connecting them together that causes problems.

Regards,
shinobi