Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,272
Default opening a workbook without knowing its exact location

Johan,

Take a look at the GetOpenFilename method in help. It gives a file browser
type dialog to go and find the file.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Johan" wrote in message
...
hello,

I'm trying to write code to open a workbook of which I don't know the

exact
location.

Can anybody help me?

Thanks, Johan




Reply
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
On Opening Excel WB the Active cell location never changes den4673 Excel Discussion (Misc queries) 1 March 4th 08 04:51 PM
Share Workbook - Knowing who is in it. B Baggins Excel Discussion (Misc queries) 0 January 24th 08 10:41 AM
How to return a specific data point from a large array if I don't know the exact location? [email protected] Excel Discussion (Misc queries) 4 May 2nd 06 03:54 PM
How to make the opening of a workbook conditional upon the opening of another workbook Marcello do Guzman Excel Programming 1 December 16th 03 06:09 AM
How to make opening of workbook conditional of opening of another workbook turk5555[_2_] Excel Programming 2 December 15th 03 11:07 PM


All times are GMT +1. The time now is 05:35 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"