Open Command
Si, try this,
Application.GetOpenFilename ("text files, *.csv")
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
"Si" wrote in message
...
Ok not sure if I'm in the right place or not.
Excel Programming?
I am building a Macro using (Application.Dialogs(xlDialogOpen).Show)
However what I cannot get it to do is Default to File Type *.csv
IE: When Open box Shows I want it to list All *.csv straight off, instead
of
having to select it from File type!
Any Help would be much appreciated!
Thanks
|