LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,510
Default finding the file path

Will the file path always be the same folder or do you mean that you have to
search for a particular file in an unknown folder on a drive?

If always in the same path then just record the macro to open the file. The
code should be something like this.

Workbooks.Open Filename:="K:\MyPath\My File To Open.xls"

--
Regards,

OssieMac


"dstiefe" wrote:

I want to open a file that is located on another harddrive and hence folder

how would I do that?

 
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
Finding the path of a folder Anne Schouten Excel Programming 3 October 2nd 07 07:40 PM
Finding a user's My Documents path Bob Excel Programming 12 August 28th 07 12:56 AM
Formula too long - new file path is shorter than old file path - Excel 2003 Greg J Excel Worksheet Functions 1 November 22nd 06 05:16 PM
Finding Current Path Mike C Excel Programming 1 April 7th 05 09:14 PM
Finding out the workgroup templates path Steven Excel Programming 1 February 3rd 04 11:39 AM


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