anish.ms
08-08-2022, 07:53 AM
Dear Experts,
I have the following 2 workbooks (1) Checklist and (2) Database. I wanted to open the Workbook("Database") when I open the Workbook("Checklist"). Currently, I have hard-coded the database location in the workbook open event. Is there any way by which the database location can be captured in the workbook open event by using an input box when a user opens the Workbook("Checklist") for the first time?
Private Sub Workbook_Open()
LPDBFile = "https://abccompany-my.sharepoint.com/personal/anish_ms_abccompany_com/Documents/Test/LP%20Database.xlsm"
Set LPDBWBook = Application.Workbooks.Open(Filename:=LPDBFile, ReadOnly:=False)
End Sub
Thanks in advance!
I have the following 2 workbooks (1) Checklist and (2) Database. I wanted to open the Workbook("Database") when I open the Workbook("Checklist"). Currently, I have hard-coded the database location in the workbook open event. Is there any way by which the database location can be captured in the workbook open event by using an input box when a user opens the Workbook("Checklist") for the first time?
Private Sub Workbook_Open()
LPDBFile = "https://abccompany-my.sharepoint.com/personal/anish_ms_abccompany_com/Documents/Test/LP%20Database.xlsm"
Set LPDBWBook = Application.Workbooks.Open(Filename:=LPDBFile, ReadOnly:=False)
End Sub
Thanks in advance!