| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Update dialog box
I have a workbook (WB01) whose Workbook_Open() subprocedure opens a second
workbook (WB02). Because WB01 is linked to WB02, the 'This workbook contains links to other data sources' dialog box is presented to the user. Is there code that I can put in the Workbook_Open subprocedure to stop this dialog box from appearing? |
|
#2
|
|||
|
|||
|
Possible answer in your other thread
-- Regards Ron de Bruin http://www.rondebruin.nl "Tim Kredlo" <Tim wrote in message ... I have a workbook (WB01) whose Workbook_Open() subprocedure opens a second workbook (WB02). Because WB01 is linked to WB02, the 'This workbook contains links to other data sources' dialog box is presented to the user. Is there code that I can put in the Workbook_Open subprocedure to stop this dialog box from appearing? |
|
#3
|
|||
|
|||
|
Hi
see if setting UpdateLinks:=True in the workbooks.open method helps -- Regards Frank Kabel Frankfurt, Germany "Tim Kredlo" <Tim schrieb im Newsbeitrag ... I have a workbook (WB01) whose Workbook_Open() subprocedure opens a second workbook (WB02). Because WB01 is linked to WB02, the 'This workbook contains links to other data sources' dialog box is presented to the user. Is there code that I can put in the Workbook_Open subprocedure to stop this dialog box from appearing? |
|
#4
|
|||
|
|||
|
Sorry for the double posting. In fact, I was surprised either of them
appeared since after hitting 'Post' I was told both times something like "Sorry. There was a problem with your post. Somebody is being notified." Thanks for the suggestion, now all I have to do is figure out 'how & where to do' what you suggested. Am I correct in assuming I need to: 1. create a class module. (I named it "claAppEvents") 2. in claAppEvents 'General' code section have something like "Public WithEvents XL As Application" 3. create a 'regular' module (I name it "modStartup") 4. in modStartup 'General' code section have something like "Dim App As New claAppEvents" 5. In my Workbook_Open()procedure for the WB01 include "Set App.XL = Application" 6. Set WB01 = Workbooks.Open(UpdateLinks:=0) "Ron de Bruin" wrote: Possible answer in your other thread -- Regards Ron de Bruin http://www.rondebruin.nl "Tim Kredlo" <Tim wrote in message ... I have a workbook (WB01) whose Workbook_Open() subprocedure opens a second workbook (WB02). Because WB01 is linked to WB02, the 'This workbook contains links to other data sources' dialog box is presented to the user. Is there code that I can put in the Workbook_Open subprocedure to stop this dialog box from appearing? |
|
#6
|
|||
|
|||
|
Editor will not allow me to enter as "UpdateLinks:=True"
If I enter it without the ":", it bombs out. "Frank Kabel" wrote: Hi see if setting UpdateLinks:=True in the workbooks.open method helps -- Regards Frank Kabel Frankfurt, Germany "Tim Kredlo" <Tim schrieb im Newsbeitrag ... I have a workbook (WB01) whose Workbook_Open() subprocedure opens a second workbook (WB02). Because WB01 is linked to WB02, the 'This workbook contains links to other data sources' dialog box is presented to the user. Is there code that I can put in the Workbook_Open subprocedure to stop this dialog box from appearing? |
|
#7
|
|||
|
|||
|
Ron,
I may not have made myself clear. I am getting the dialog box when I open the first workbook, WB01, not when the second, WB02, is opened. Doesn't this solution address the situation where WB02 was linked to a third file? By the way, everytime I post I get the same "there was a problem with your post......" message. Is this normal? Thanks again for your help. Tim Kredlo "Ron de Bruin" wrote: Hi Tim Use it like this in the Thisworkbook module of WB01 Private Sub Workbook_Open() Dim WB02 As Workbook Set WB02 = Workbooks.Open("C:\Data\test1.xls", UpdateLinks:=0) End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Tim Kredlo" <Tim wrote in message ... Sorry for the double posting. In fact, I was surprised either of them appeared since after hitting 'Post' I was told both times something like "Sorry. There was a problem with your post. Somebody is being notified." Thanks for the suggestion, now all I have to do is figure out 'how & where to do' what you suggested. Am I correct in assuming I need to: 1. create a class module. (I named it "claAppEvents") 2. in claAppEvents 'General' code section have something like "Public WithEvents XL As Application" 3. create a 'regular' module (I name it "modStartup") 4. in modStartup 'General' code section have something like "Dim App As New claAppEvents" 5. In my Workbook_Open()procedure for the WB01 include "Set App.XL = Application" 6. Set WB01 = Workbooks.Open(UpdateLinks:=0) "Ron de Bruin" wrote: Possible answer in your other thread -- Regards Ron de Bruin http://www.rondebruin.nl "Tim Kredlo" <Tim wrote in message ... I have a workbook (WB01) whose Workbook_Open() subprocedure opens a second workbook (WB02). Because WB01 is linked to WB02, the 'This workbook contains links to other data sources' dialog box is presented to the user. Is there code that I can put in the Workbook_Open subprocedure to stop this dialog box from appearing? |
|
#8
|
|||
|
|||
|
Doesn't this solution address the situation where WB02 was linked to a third
file? Yes I misunderstood you If you use Excel 2002 or 2003 you have this option in Edit Links Change it and save the file. -- Regards Ron de Bruin http://www.rondebruin.nl "Tim Kredlo" wrote in message ... Ron, I may not have made myself clear. I am getting the dialog box when I open the first workbook, WB01, not when the second, WB02, is opened. Doesn't this solution address the situation where WB02 was linked to a third file? By the way, everytime I post I get the same "there was a problem with your post......" message. Is this normal? Thanks again for your help. Tim Kredlo "Ron de Bruin" wrote: Hi Tim Use it like this in the Thisworkbook module of WB01 Private Sub Workbook_Open() Dim WB02 As Workbook Set WB02 = Workbooks.Open("C:\Data\test1.xls", UpdateLinks:=0) End Sub -- Regards Ron de Bruin http://www.rondebruin.nl "Tim Kredlo" <Tim wrote in message ... Sorry for the double posting. In fact, I was surprised either of them appeared since after hitting 'Post' I was told both times something like "Sorry. There was a problem with your post. Somebody is being notified." Thanks for the suggestion, now all I have to do is figure out 'how & where to do' what you suggested. Am I correct in assuming I need to: 1. create a class module. (I named it "claAppEvents") 2. in claAppEvents 'General' code section have something like "Public WithEvents XL As Application" 3. create a 'regular' module (I name it "modStartup") 4. in modStartup 'General' code section have something like "Dim App As New claAppEvents" 5. In my Workbook_Open()procedure for the WB01 include "Set App.XL = Application" 6. Set WB01 = Workbooks.Open(UpdateLinks:=0) "Ron de Bruin" wrote: Possible answer in your other thread -- Regards Ron de Bruin http://www.rondebruin.nl "Tim Kredlo" <Tim wrote in message ... I have a workbook (WB01) whose Workbook_Open() subprocedure opens a second workbook (WB02). Because WB01 is linked to WB02, the 'This workbook contains links to other data sources' dialog box is presented to the user. Is there code that I can put in the Workbook_Open subprocedure to stop this dialog box from appearing? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Update linked cells within a workbook??? | Links and Linking in Excel | |||
| Update Individual Links | Excel Discussion (Misc queries) | |||
| Using the "Go To" dialog for "Copy" | Excel Discussion (Misc queries) | |||
| Automatic Chart Update? | Charts and Charting in Excel | |||
| Update / don't update dialog box | Excel Worksheet Functions | |||
Linear Mode
