Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 12-19-2023, 09:17 AM
MartinGM MartinGM is offline Opening a document with links - from VBA Windows 11 Opening a document with links - from VBA Office 2021
Competent Performer
Opening a document with links - from VBA
 
Join Date: May 2023
Location: England
Posts: 101
MartinGM is on a distinguished road
Default 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
Reply With Quote
 



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
Opening a document with links - from VBA VBA Code to prevent word document trying to open links at opening John Pryor Word VBA 4 07-17-2018 01:51 AM
Opening a document with links - from VBA 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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:42 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft