Open / Save As Files

[John McGraw]

Is there a way to open/saveas files, in _VBA_ without specifying the name of the file in the code?

I mean, let the user browse the directories and choose whatever file he wants. The way open would work if you went to FILE|OPEN?

Thanks.

 

[Juan Pablo González]

This is just 4 topics below !

http://www.mrexcel.com/board/viewtopic.php?topic=2793&forum=2&2

 

[John McGraw]

Whooops... Sorry!!

I did do a search to find if my question was answered, but didnt notice that thread!

Thanks,
John

 

[John McGraw]

Follow up question:

Is there a way to specify the path that automatically comes up when you do a "GetOpenFileName"?

I've tried application.defaultpath, but that doesnt work.

 

[Ivan F Moala]

On 2002-03-19 22:35, John McGraw wrote:
Follow up question:

Is there a way to specify the path that automatically comes up when you do a "GetOpenFileName"?

I've tried application.defaultpath, but that doesnt work.

Use syntax;

ChDir "C:"

To change to the dir before calling getopen..