Path for File Saving Defined by USER

Have you looked at Application.SaveAsFileName. This routine shows how it goes.

Please Login or Register  to view this content.

Note that it does not save the file. The built in SaveAs dialog does that.

Please Login or Register  to view this content.

will return didSave=True if the file is saved, didSave=False if Cancel is pressed.

There is also a Save Copy As dialog like the above, xlDialogSaveCopyAs.

Hey Thanks Mike,

But to be frank... I am not an VBA champ.... I tried to juggle the codes you provided... but cudnt get what i want...

As you can see in my code... that I want create a .txt file out of the macro..

Thats what i can not do now...

Help me ...

I've altered your code to include the user choice.

Please Login or Register  to view this content.

Thanks A lot ...