LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 258
Default Open workbook in user-defined folder

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Storing User Defined Functions in Office\Library folder for MAC's Carrie_Loos via OfficeKB.com Excel Discussion (Misc queries) 0 April 1st 09 05:51 PM
Opening workbook in user-defined folder pdberger Excel Worksheet Functions 0 August 26th 05 04:09 PM
Open an Outlook folder when a user clicks on a command button ... Rob Keel Excel Discussion (Misc queries) 2 August 1st 05 08:23 AM
Create User Defined Folder Delboy Excel Programming 1 February 8th 05 01:19 AM
User-defined data type; Error: Only User-defined types... tiger_PRM Excel Programming 1 July 18th 04 03:32 PM


All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"