Open / Save As Files

John McGraw · Mar 19th, 2002, 08:56 PM

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 · Mar 19th, 2002, 08:58 PM

This is just 4 topics below !

http://www.mrexcel.com/board/viewtop...2793&forum=2&2

John McGraw · Mar 19th, 2002, 10:58 PM

Whooops... Sorry!!

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

Thanks,
John

John McGraw · Mar 19th, 2002, 11:35 PM

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 · Apr 3rd, 2002, 11:31 PM

Quote:

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..

Mar 19th, 2002, 08:58 PM	#2
Juan Pablo González MrExcel MVP Join Date: Feb 2002 Location: Bogota, Colombia Posts: 11,927	This is just 4 topics below ! http://www.mrexcel.com/board/viewtop...2793&forum=2&2 __________________ Regards, Juan Pablo González http://www.juanpg.com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 19th, 2002, 08:56 PM	#1
John McGraw Board Regular Join Date: Feb 2002 Posts: 76	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.

Mar 19th, 2002, 10:58 PM	#3
John McGraw Board Regular Join Date: Feb 2002 Posts: 76	Whooops... Sorry!! I did do a search to find if my question was answered, but didnt notice that thread! Thanks, John

Mar 19th, 2002, 11:35 PM	#4
John McGraw Board Regular Join Date: Feb 2002 Posts: 76	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.