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)
Merge changes prompt
-
- BronzeLounger
- Posts: 1254
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
-
- 5StarLounger
- Posts: 689
- Joined: 27 Jan 2010, 16:45
- Location: Ottawa, Ontario, Canada
-
- BronzeLounger
- Posts: 1254
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Merge changes prompt
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..
Problem is also that this automatically selects the DEFAULT prompt: that is MERGE in this case and I don't want that..
-
- Administrator
- Posts: 78531
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Merge changes prompt
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...)
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
Hans
-
- BronzeLounger
- Posts: 1254
- Joined: 03 Feb 2010, 19:59
- Location: Terneuzen, the Netherlands
Re: Merge changes prompt
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.