Re: Set the path

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Tom Ogilvy (twogilvy_at_msn.com)
Date: 06/13/04

Next message: Tom Ogilvy: "Re: How have text on clipboard reformatted as a cell would be put there?"
Previous message: N E Body: "Re: Spinbutton help required"
In reply to: Grace: "Set the path"
Next in thread: Grace: "Re: Set the path"
Reply: Grace: "Re: Set the path"
Messages sorted by: [ date ] [ thread ]

Date: Sun, 13 Jun 2004 16:12:54 -0400

http://j-walk.com/ss/excel/tips/tip29.htm
Selecting a Directory

-- 
Regards,
Tom Ogilvy
"Grace" <Whooshbopbang4@adelphia.net> wrote in message
news:I_mdnTuCt_wnMlHdRVn-vg@adelphia.com...
> My subroutines open up a lot of files with very specific names.  I will be
> careful to give those files the right names before starting the macro.
>
> One thing I'm having trouble with is telling it the right path and folder
to
> look in.  Though I could try to automate the pathname too, I am starting
to
> think that it would be just best to have the macro let me browse to the
> folder, WITHOUT even opening a file.   can someone suggest some VBA code
to
> have it let me browse to a folder and then set that folder as the default
> place to look for any files I am to LATER open, even the very first one.
>
> Thanks,
> Grace
>
>

Next message: Tom Ogilvy: "Re: How have text on clipboard reformatted as a cell would be put there?"
Previous message: N E Body: "Re: Spinbutton help required"
In reply to: Grace: "Set the path"
Next in thread: Grace: "Re: Set the path"
Reply: Grace: "Re: Set the path"
Messages sorted by: [ date ] [ thread ]