filesaveas question

J

Joy

I notice that

FileSaveAs Name:="C:\Documents and Settings\<user>\Desktop\1.mpp",
FormatID:="MSProject.MPP"

if 1.mpp already exists, then you will get a messagebox asking you whether
to replace the file ot cancel

if I click cancel, I will get an unexpected error. err number: 1004

I do not want the message show, and I want the user to try again if he/she
click "cancel".

like what it does in File-SaveAs, if you choose a file that already exists,
if you click "cancel", you will not get any error message.

I do not simply add on error goto ...

thank you!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top