I have a series of macros in an Excel file that users use to creat
spreadsheets. When they are finished creating spreadsheets they ca
print "reports" in Word. To do this I am controlling Word from Exce
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 th
error box "Word has encountered a problem and needs to close" and i
then asked to send or not send an error report. Once he clicks eithe
of these options the Excel macro fails because it is trying to talk t
Word that isn't there. Since he is so far away I cannot tell what i
going wrong. Like I said, no one else has these problems and the res
of the macro works fine for him.

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

--
JFamil
-----------------------------------------------------------------------
JFamilo's Profile: http://www.excelforum.com/member.php...fo&userid=1727
View this thread: http://www.excelforum.com/showthread.php?threadid=39546

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

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" 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:
\

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?