Thread: Open Command
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Paul B Paul B is offline
external usenet poster
 
Posts: 709
Default 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