How to make automatic save in Words & Excell pls?

[zach007]

Dear Experts,

I am creating template documents using words and excel...What I am trying to do is, when users have finished filled out the form template when they click on "Save" it will automatically save current file into desired location folder such as "C:\MyDocuments\Invoice\" and disable asking where users want to put the file as default....such as "asking where to put the file with enabling browser location to save"....

Anyone could help me please...

Thanks a lot,

Jennifer ;)

[Hack]

What about a file name? Is it always going to be named the same thing, which would be something you have hardcoded, and thus, always overlaying what was there previously?

[zach007]

Usually...at the first time, when user press "Save"...it ask to users where they would like to save the file (as a pop up/dialog windows)...what I would like to try is, rather than showing a dialog window at the first time of saving, it will automatically save to appointed location...

[Hack]

Usually...at the first time, when user press "Save"...it ask to users where they would like to save the file (as a pop up/dialog windows)...what I would like to try is, rather than showing a dialog window at the first time of saving, it will automatically save to appointed location...Ok. Does VBA have an Inputbox? Is so, you can pop that up and ask them what name they want to use for the file. Once that have put that in, you can append your default path to it, and to a SaveAs:

[zach007]

Hi,

Thanks for your reply...Do you know the codes please..???..Is it possible if you show me the code please so I can learn from it..???

Thanks a lot for your kind helps..