ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Failure to execute Private Workbook_Open (https://www.excelbanter.com/excel-programming/390728-failure-execute-private-workbook_open.html)

Rick

Failure to execute Private Workbook_Open
 
I find that when I execute a Public Static Workbook_Open routine (Book1
opening Book2) that Book2 Private Sub Workbook_Open procedure in ThisWorkbook
does not call a sub that is to be executed upon the opening of the workbook.
Any Suggestions? Example: Book1:::
Public Static Sub OpenFiles(BkNme)
Dim WorkBk As Workbook
Dim WrkBk As String
Dim BKPath As String
Set ThsWrkBk = ActiveWorkbook
BKPath = "C:\Documents and Settings\Richard L. Harig\My
Documents\Excell\Financials\"
WrkBk = BKPath & BkNme
On Error Resume Next
Set WorkBk = Workbooks(BkNme)
If WorkBk Is Nothing Then
On Error Resume Next
Workbooks.Open Filename:=WrkBk, UpdateLinks:=3
End If
End Sub

Book2::
Private Sub Workbook_Open()
Call MedExp
End Sub



All times are GMT +1. The time now is 09:52 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com