MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Open workbook macro

Posted by Ben T on December 22, 2000 2:10 PM

How do I create a macro that opens a workbook with the name Videos.xls that is in the same directory as the workbook that is open and running the macro. It needs to be able to open it from any directory as long as they are both in that directory.

Posted by cpod on December 22, 2000 4:41 PM

Just enter this code to run on a button click:

Workbooks.Open (ThisWorkbook.Path & "\videos.xls")

Posted by Ben on December 23, 2000 3:04 AM