Using forms and modules from one workbook into another excel file

[marlonsaveri]

Hello, I build some modules and forms in a test file. However, routines, functions, etc. should run to another file, a "main file".
To "move" commands, I copied the modules from one and pasted it; I exported forms and imported them in the "main file"

However, every time I open this main workbook:

1. It asked twice to disable macros.

2. it opens the file test in order to use the forms. When I tried to save the file to my computer from a PenDrive; or two messagens appears to disable macros or it just save the old file, without enough data.

I don't know if it's important to say, but, in principle, this other file was not xlsm, but had a different format what opens in excel as well.

 

[Rasm]

Not sure what it is you are trying to do - but here is what I understand

1) Program resides in one XLSM or XLAM file

2) your data reside in a normal XLSX

So if that is true simply run your user form - properly should load using

ThisWorkBook_open event

Private Sub Workbook_Open()
    Load NameOfUserform
    NameOfUserform.Show vbModeless 'If you use modeless you can still edit the sheet.
End Sub

- that way the userforms loads automatically - now open you XLS file with data - Not sure if this is what you are asking!