[AccessD] GetOpenFilename function

Arthur:

In the file open dialog box routine that I'm using  the default folder is an
option which you can pass to the routine.  Does your File Open Dialog Box
code allow for this option? Unless the folder you want to start in is the
same as where the Excel file is stored, you'd have to save the path as a
preference - probably in a cell of the spreadsheet.  The first time, of
course, it would be blank.  The second time you could pick up the starting
folder from that cell.

Rocky
 




 	
	

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Arthur Fuller
Sent: Wednesday, September 12, 2007 10:00 AM
To: Access Developers discussion and problem solving
Subject: [AccessD] GetOpenFilename function

I'm calling this function from Excel code. My question is, can I somehow
specify the starting path in which the user begins browsing? The directory
structure is very deep and typically the user has to navigate first to the
drive and then about 8 levels in. I'd like to supply the default drive
letter and as much of the tree as possible.

TIA,
Arthur
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com

No virus found in this incoming message.
Checked by AVG Free Edition. 
Version: 7.5.485 / Virus Database: 269.13.15/1002 - Release Date: 9/11/2007
5:46 PM