EXCEL for MAC: Event Macro to Open 2 workbooks at same time

[KerryFSA]

The macro below is copied from a Windows VBA tutorial.

Doesn't work on my Mac.
Can anyone sort out the syntax problem?
It should open a dialogue box to locate the file that should be opened.
I want to open a second workbook when a first WB is opened.
Thanks.



Sub Open_Workbook_Dialogue()

Dim wb As Variant

wb = Application.GetOpenFilename(FileFilter:=”Excel Files,*.xl*;*.xm*”)
If wb <> False Then
Workbooks.Open FileName:=wb
End If

End Sub

 

[Joe4]

I am not up-to-date on all the differences between Excel for PC vs Excel for Mac, but if the event procedures are the same, there is no "Open_Workbook_Dialogue()" event procedure, just "Workbook_Open".

See here to see how to set it up so that it automatically runs upon opening an Excel file: https://support.office.com/en-us/ar...workbook-1e55959b-e077-4c88-a696-c3017600db44

 

[KerryFSA]

I am not up-to-date on all the differences between Excel for PC vs Excel for Mac, but if the event procedures are the same, there is no "Open_Workbook_Dialogue()" event procedure, just "Workbook_Open".

Hi Joe,
Thanks very much. I already use (successfully) the Open workbook routine. If there is no such thing as
Sub Open_Workbook_Dialogue(), I'll just place code and a dialogue box within the one I'm already using.
Kerry

 

[Joe4]

Thanks very much. I already use (successfully) the Open workbook routine. If there is no such thing as
Sub Open_Workbook_Dialogue(), I'll just place code and a dialogue box within the one I'm already using.

Yes, that is what you want to do.
By the way, where did Open_Workbook_Dialogue come from? Did you see it used somewhere?

 

[KerryFSA]

[/I]Yes, that is what you want to do.
By the way, where did Open_Workbook_Dialogue come from? Did you see it used somewhere?

It was some time ago and i don't remember from whence it came.

 

[Joe4]

It was some time ago and i don't remember from whence it came.

I was just curious, because I have never seen it, and a Google search returned nothing.
Excel Event Procedures (code that runs automatically upon some event happening) and VERY specific and must be named exactly a certain way (they are all pre-defined), so you cannot choose your own name for them.

Perhaps someone had create some code and named it that, in which case, it would NOT be an event procedure, and not would automatically run. However, it could be called by an event procedure (i.e. maybe they called it from a Workbook_Open event).