Error while controlling Word from Excel

[JFamilo]

I have a series of macros in an Excel file that users use to create spreadsheets. When they are finished creating spreadsheets they can print "reports" in Word. To do this I am controlling Word from Excel with VBA. This works fine for all of the associates in my office. However, I have an associate in another office (about 1500 miles away) that has Word crash whenever he tries to run reports. He gets the error box "Word has encountered a problem and needs to close" and is then asked to send or not send an error report. Once he clicks either of these options the Excel macro fails because it is trying to talk to Word that isn't there. Since he is so far away I cannot tell what is going wrong. Like I said, no one else has these problems and the rest of the macro works fine for him.

I talked to our corporate "help" people but they of course were no help whatsoever. The excel file with all the macros is located on our shared drive that this associate also has access to. Any ideas of what could be causing this or how to fix it?

[Rafael Guerreiro Osorio]

If he has access to the administrative tools, tell him to search for the ID
of the error/event in the applications log (sorry, my Windows is in
Portuguese, so I don't recall the correct name). Then see if you can find any
info on it. The problem might be in his machine, or Word/Office installation.
I had a bad memory module once that generated this kind of behavior, and it
took a long time before I found out there was nothing wrong with my
software...

Best

Rafael

"JFamilo" wrote:

>
> I have a series of macros in an Excel file that users use to create
> spreadsheets. When they are finished creating spreadsheets they can
> print "reports" in Word. To do this I am controlling Word from Excel
> with VBA. This works fine for all of the associates in my office.
> However, I have an associate in another office (about 1500 miles away)
> that has Word crash whenever he tries to run reports. He gets the
> error box "Word has encountered a problem and needs to close" and is
> then asked to send or not send an error report. Once he clicks either
> of these options the Excel macro fails because it is trying to talk to
> Word that isn't there. Since he is so far away I cannot tell what is
> going wrong. Like I said, no one else has these problems and the rest
> of the macro works fine for him.
>
> I talked to our corporate "help" people but they of course were no help
> whatsoever. The excel file with all the macros is located on our shared
> drive that this associate also has access to. Any ideas of what could
> be causing this or how to fix it?
>
>
> --
> JFamilo
> ------------------------------------------------------------------------
> JFamilo's Profile: http://www.excelforum.com/member.php...o&userid=17276
> View this thread: http://www.excelforum.com/showthread...hreadid=395466
>
>

[KimR.Hammel]

I have been trying to do a very similar thing. Could you possibly send me
your workbook and VBA code to use as a template?

[KimR.Hammel]

"KimR.Hammel" wrote:

I have been trying to do a very similar thing. Could you possibly send me
your workbook and VBA code to use as a template?

My email is as follows:
\
[email protected]

[Jon Peltier]

Does your Excel VBA project have a reference to the Word object model?
Presumably everyone in your office has the same version of Word, so
there's no incompatibility. If you have a reference to a later version
of Word than is used by the person outside your office, you could be
getting errors. The options you have are to set a reference to an older
Word object library, or convert to late binding (remove the reference,
declare Word variables as objects, and convert Word-specific constants
to their numerical values).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

JFamilo wrote:

> I have a series of macros in an Excel file that users use to create
> spreadsheets. When they are finished creating spreadsheets they can
> print "reports" in Word. To do this I am controlling Word from Excel
> with VBA. This works fine for all of the associates in my office.
> However, I have an associate in another office (about 1500 miles away)
> that has Word crash whenever he tries to run reports. He gets the
> error box "Word has encountered a problem and needs to close" and is
> then asked to send or not send an error report. Once he clicks either
> of these options the Excel macro fails because it is trying to talk to
> Word that isn't there. Since he is so far away I cannot tell what is
> going wrong. Like I said, no one else has these problems and the rest
> of the macro works fine for him.
>
> I talked to our corporate "help" people but they of course were no help
> whatsoever. The excel file with all the macros is located on our shared
> drive that this associate also has access to. Any ideas of what could
> be causing this or how to fix it?
>
>