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: 3
Default Local Directory File Access

Hello all,

I am trying to get a macro to open a file in the same directory as the xl
file being launched. The code I am using is:
Workbooks.Open Filename:="DB-Data.xls"

For some reason it doesn't want to find it [although the help file says that
it should]. If I give it a full path, it has no problem. Is it possible to
do this? My goal is to get these workbooks available on CD for people to
work at home.

Thanks,
-=Alejandro


 
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
Excel Very Slow when Using Network Account to Access Local File Joannie Excel Discussion (Misc queries) 0 March 26th 08 05:28 PM
Hypoerlink to a Local file and emailing the file as an attachment JohnH Excel Discussion (Misc queries) 0 January 2nd 07 06:45 PM
Accessing local workstation's TEMP directory Frederick Chow Excel Programming 5 March 20th 06 05:04 PM
How to write a micro to download file at a URL save the file at the local PC www.microsoft.com Excel Programming 2 March 9th 06 02:21 AM
How to access a database on a server from a local machine using od Todd W Excel Discussion (Misc queries) 0 December 15th 05 03:16 PM


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