Update / don't update dialog box

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a workbook (WB01) that contains a macro to open a second workbook
(WB02). WB01 has links to WB02, so when WB01 is opened, the 'This workbook
contains links to other data sources' dialog box is presented.

How can I code my WB01 Workbook_Open() subprocedure to suppress this dialog
box?
 
Hi Tim

Set mybook = Workbooks.Open(FNames, Password:="ron", WriteResPassword:="ron", UpdateLinks:=0)

If your workbooks are protected you can us this in the Workbooks.Open arguments
Password:="ron" and WriteResPassword:="ron"

If you have links in your workbook this (UpdateLinks:=0) will avoid the message
do you want to update the links or not < 0 Doesn't update any references >

See the VBA help for more information about the Workbooks.Open arguments
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update dialog box 7
Link To File That No Longer Exists 1
Macro warning - how to delete macro 3
Excel 2007 Move or Copy worksheet 2
Automatically Close Dialog Boxes 2
Excel Macro to un-mute Audio/speakers. 15
Unnamed Macro Error 2
Links to Dynamic Named Range = Problem 8

Back
Top