#1
|
|||
|
|||
Opening a document with links - from VBA
When I open a Word document with links (for instance a mailmerge) I get a dialog "Yes" or "No" to allow SQL access. I select "Yes" and away I go.
When I open the same document from VBA it opens without showing the dialog, having assumed that the answer is "No". Then I can't do anything with the document. Is there a way from VBA to open the document to the dialog so that I can answer the question as "Yes" ? Or is there another workaround to open the document with SQL access ? Many thanks |
#2
|
|||
|
|||
I turn the document into a non-mailmerge document before saving and closing it. Then, the vba to open changes it back to a letter mailmerge prlimary and attaches the data source.
|
#3
|
|||
|
|||
Thanks Charles - I'll try that workaround
|
#4
|
|||
|
|||
Hi,
I've looked, but cannot find how to . . "Then, the vba to open changes it back to a letter mailmerge prlimary and attaches the data source." Could you point me at appropriate instructions please ? Thank you, |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
A few links opening incorrectly | dsrt16 | PowerPoint | 0 | 07-19-2023 10:47 AM |
How to to automatically update Word links with Mail Merge, when opening Word file from Excel? | soroush.kalantari | Word VBA | 1 | 05-23-2023 11:36 PM |
VBA Code to prevent word document trying to open links at opening | John Pryor | Word VBA | 4 | 07-17-2018 01:51 AM |
Can links move with the document? | Fabulist | Word | 17 | 01-27-2018 03:46 AM |
Opening a word doc without opening all attached links/reference | Nicobisgaard | Word | 9 | 07-21-2015 08:49 AM |