Automatically Save

[dodom75]

Hi,

I have the code below, and after the first code ran I wanted the file to automatically save, but I am getting a compile error. Can anyone tell me how this should be written?

Thanks

Please Login or Register  to view this content.

Please Login or Register  to view this content.

[shg]

I don't get a compile error.

[dodom75]

Thank you for the quick response. I did try to rerun and did not get the compile error but it did not save either. If I wanted to put this line of code in the existing macro that functions off the command button where will it go?

Please Login or Register  to view this content.

[dodom75]

Thank you, I found the instructions and will go into my other posts and wrap those as well.

Please let me know if you can answer my question. Thanks

[shg]

If I wanted to put this line of code in the existing macro ... where will it go?

At a glance, just before the End Sub.

[dodom75]

Thanks for all your help. I ended up just having to build a separate macro (below).

Thanks again.

Please Login or Register  to view this content.