Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I've written a set of two workbooks for use by many different people.
"Instrument Panel User Data.xls" calls information out of "Instrument Panel Reference Data.xls". I don't know where each user will store these two files but I want to set things up so that, as long as they're in the same folder, the 'User Data' will find and open 'Reference Data'. My code don't work! Here it is: Private Sub Workbook_Open() Dim File_Path As String Dim File_Name As String File_Path = ThisWorkbook.Path File_Name = File_Path + "Instrument Panel Reference Data.xls" Workbooks.Open Filename:="File_Name" End Sub What am I doing wrong? Do I have to slit my wrists? Say it ain't so! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Storing User Defined Functions in Office\Library folder for MAC's | Excel Discussion (Misc queries) | |||
Opening workbook in user-defined folder | Excel Worksheet Functions | |||
Open an Outlook folder when a user clicks on a command button ... | Excel Discussion (Misc queries) | |||
Create User Defined Folder | Excel Programming | |||
User-defined data type; Error: Only User-defined types... | Excel Programming |