Getting file path

[fengw]

Hi,

I'd like to get a filepath such that I can save a text file to by prompting the user with a dialog box, but I'm not sure how to do so.

I'm thinking Application.GetSaveAsFileName should supposedly work, but I get the error: "Object doesn't support this property or method." Is this because I don't have a reference to something? Or is there another way to do this?


Thanks!

[JP2112]

Try this:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=284

FYI Application.GetSaveAsFileName only works in Excel.