?

your link suggests that you want to set the file path to the folder ....

your code is incorrect ...

you have

ChDrive = "C"

it should be

ChDrive "C"

so

ChDrive "C"
ChDir "C:\Temp"
myFileName = Application.GetOpenFilename("CSV Files, *.CSV",, "Pick a File")








"Paul H" wrote in message
...


================================================== ========

Please show me what you suggest I try, and I will try it.

================================================== ========

"Patrick Molloy" wrote in message
...
no "="
use
ChDrive "C"

================================================== ========


"Paul H" wrote in message
...

================================================== ========

Joel or Shane, click on this link to a long web page that I created to
show
screen-print examples of my progress.

www.verifycharges.com/Excel1/sample1.htm

================================================== ========

"Joel" wrote in message
...
I'm not sure I understand your problem. Do you wan to only display the
files
in a certain folder? You can use a listbox and manually fill the list
box
with the items in one folder. I believe if you use a win32 object you
can
lock the dialog to display only one folder.

If you want to set a default folder then use the filedialog method
instead
of GetOpenFilename. See VBA help

================================================== ========

"Paul H" wrote:



Shane, will you show me what to specify if my files are in C:\aaa but I
cannot change from the folder where I am running my programs? Your help
explanation is not clear. My actual path will be much more complex,
involving a mapped drive, but the C:\aaa example should set me right.

"Shane Devenshire" wrote in
message ...
Hi,

I don't have time to try to follow all the earlier stuff in this thread,
however the line

myFileName = Application.GetOpenFilename("CSV Files, *.CSV",, "Pick a
File")

gets both the file name and path, so you just put myFileName in where
ever
you need it.

As you can see I made a change to this line, not because it affect
anything
it just makes it easier to display on one line here. It also shows that
the
argument name is not technically necessary, in which case you must put
the
arguments in the correct order.

Here is the Help explanation:

Displays the standard Open dialog box and gets a file name from the user
without actually opening any files.

expression.GetOpenFilename(FileFilter, FilterIndex, Title, ButtonText,
MultiSelect)
expression Required. An expression that returns an Application
object.

FileFilter Optional Variant. A string specifying file filtering
criteria.

This string consists of pairs of file filter strings followed by the
MS-DOS
wildcard file filter specification, with each part and each pair
separated
by
commas. Each separate pair is listed in the Files of type drop-down list
box.
For example, the following string specifies two file filters€” text and
addin:
"Text Files (*.txt),*.txt,Add-In Files (*.xla),*.xla".

To use multiple MS-DOS wildcard expressions for a single file filter
type,
separate the wildcard expressions with semicolons; for example, "Visual
Basic
Files (*.bas; *.txt),*.bas;*.txt".

If omitted, this argument defaults to "All Files (*.*),*.*".

FilterIndex Optional Variant. Specifies the index numbers of the
default
file filtering criteria, from 1 to the number of filters specified in
FileFilter. If this argument is omitted or greater than the number of
filters
present, the first file filter is used.

Title Optional Variant. Specifies the title of the dialog box. If
this
argument is omitted, the title is "Open."

ButtonText Optional Variant. Macintosh only.

MultiSelect Optional Variant. True to allow multiple file names to be
selected. False to allow only one file name to be selected. The default
value
is False

Remarks
This method returns the selected file name or the name entered by the
user.
The returned name may include a path specification. If MultiSelect is
True,
the return value is an array of the selected file names (even if only
one
filename is selected). Returns False if the user cancels the dialog box.

This method may change the current drive or folder.

Example
This example displays the Open dialog box, with the file filter set to
text
files. If the user chooses a file name, the code displays that file name
in
a
message box.

fileToOpen = Application _
.GetOpenFilename("Text Files (*.txt), *.txt")
If fileToOpen < False Then
MsgBox "Open " & fileToOpen
End If



--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Paul H" wrote:


================================================== =======

Dave,
Thank so much. It works perfectly. I just need to tell it what
folder
to
be looking in, to make the file selection. It will be a long path on
a
networked drive.
I bought a book that should help me figure these things out myself -
Excel
2007 Power Programming with VBA (Mr. Spreadsheet's Bookshelf) by John
Walkenbach.
Paul