Open Word Document and Accept Track Changes - Partial Solution
I am having a problem with a similar stmt (my query on this forum is
slightly older -- 1 NOV 7:09AM; the Subject is == Running Macro
"Logged Off" & Copy/Paste from WORD .rtf into EXCEL .xls
Two changes in my posted code: my file open stmt is now
'Set objDoc = objWord.Documents.Open ("C:\Test\T and A.rtf")';
and I deleted the next stmt 'objDoc.Activate'.
When my machine is "logged on", my code works as intended. However,
when "logged off" our network, my code stops processing at my revised
'Set objDoc = ...' stmt. And I have about 100 lines of EXCEL VBA code
that is processed before it reaches that point.
Any ideas?
JingleRock
|