Merge changes prompt

User avatar
ErikJan
BronzeLounger
Posts: 1254
Joined: 03 Feb 2010, 19:59
Location: Terneuzen, the Netherlands

Merge changes prompt

Post by ErikJan »

I'm opening a Word coument in Word (from Excel VBA). I get a "Do you want to merge changes..." prompt but I don't want that (No,I don't want to merge changes). How do I prevent that in vba?

Excel call is:
Set wordDoc = wordApp.Documents.Open(myPath + f, , True)

User avatar
Don Wells
5StarLounger
Posts: 689
Joined: 27 Jan 2010, 16:45
Location: Ottawa, Ontario, Canada

Re: Merge changes prompt

Post by Don Wells »

Have you tried:

Aplication.DisplayAlerts = False
Regards
Don

User avatar
ErikJan
BronzeLounger
Posts: 1254
Joined: 03 Feb 2010, 19:59
Location: Terneuzen, the Netherlands

Re: Merge changes prompt

Post by ErikJan »

That doesn't work (tried that). Maybe I should do that in Word...?

Problem is also that this automatically selects the DEFAULT prompt: that is MERGE in this case and I don't want that..

User avatar
HansV
Administrator
Posts: 78531
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Merge changes prompt

Post by HansV »

If

wordApp.DisplayAlerts = False

doesn't help, you might try

SendKeys "N"

(I would have thought that everybody would have turned off the "Add properties to attachments to enable Reply with Changes" setting in Outlook that causes this prompt by now...)
Best wishes,
Hans

User avatar
ErikJan
BronzeLounger
Posts: 1254
Joined: 03 Feb 2010, 19:59
Location: Terneuzen, the Netherlands

Re: Merge changes prompt

Post by ErikJan »

Thanks, I found the Word displayalerts worke for me. The Word docs were attachments to emails but I opened them from a folder on my HD.