Changing default file location in Save As Macro

[jordan2322]

Hi Everyone,

I just want to change the default view to save the file as when the user runs the macro from below.

Ideally I would like to be able to set the save location to something like:

Please Login or Register  to view this content.

and the macro would use Path as the default to display as the save location when the dialogue box appears

Here is the code i am using to run the save as

Please Login or Register  to view this content.

kind regards

[Leith Ross]

Hello jordan2322,

Your macro will now set the default directory to what you choose. In the code it is set to "C:\Test Folder". Change this path to what you want to use. The macro will remember the original setting and restore it before finishing.

Please Login or Register  to view this content.

[jordan2322]

Thanks for your reply Leith.

Im getting an error 424 Object required when running this code on line:
CurDir = SaveToDir ' Change the default save to path.

Whats causing this do you think?

[Leith Ross]

Hello jordan2322,

I thought I deleted the equal sign before posting the code. It should be...

Please Login or Register  to view this content.

The same holds for this line. Remove the equal sign.

Please Login or Register  to view this content.

[jordan2322]

Thanks Leith! works perfect now