Separating Forms from database

[Chino21]

Hi guys,

What im planning is to separate my forms from my database so that it will be easier to load the form/file since it will be shared. The two workbook will be saved on our network ("W"). The workbook for the forms will be under W:\forms while the database will be at W:\data.

Its like the forms are calling the workbook located in W:\data

Both with the same filename: Metric.xlsm

 

[Chino21]

Hi guys,

What im planning is to separate my forms from my database so that it will be easier to load the form/file since it will be shared. The two workbook will be saved on our network ("W"). The workbook for the forms will be under W:\forms while the database will be at W:\data.

Its like the forms are calling the workbook located in W:\data

Both with the same filename: Metric.xlsm

I have tried this

Workbooks.Open Filename:="network path\filename"

Gave me an error that the file is already opened. So I changed the filename of the other file to database.

Workbooks.Open Filename:="W:\data\database.xlsm"

Now, i noticed that the two files were loaded (database and metric). Is there anyway that database.xlsm will not be loaded.