Opening Userform1 in Book1 from a button on Userfrom2 in Book2

[chazrab]

Names in title are generic for simplicity. I can replace those with the correct file name(s) and Userform(s)
I can't figure out how this can be done.
This is the actual File path where File with NewDEForm (actual form name) is located:

C:\Users\car19\Dropbox\2024 .xlsm

This is rhe actual Userform name that needs to be opened by Book2:

NewDEForm

How would I open NewDEForm from Book2 ? I tried this - it generates an error:
From a button click in Book2:

C:\Users\car19\Dropbox\2024 .xlsm\NewDEForm

Any help would be greatly appreciated.

cr

 

[bobsan42]

First you need to prepare a sub in a public module in Book1 which opens UserForm1. Something like:

Public Sub openForm()
    NewDEForm.show
End Sub

Save Book1.

then in Book2 you do something like this:

set wb = Application.Workbooks.Open ("C:\Users\car19\Dropbox\2024 .xlsm")
Application.Run ("'" & wb.name & "'!openForm")