Macro Saves to Incorrect Directory

[kirsty]

I've got the following code in my simple user form used to save three types of documents to the appropriate folder:

Please Login or Register  to view this content.

For some reason I cannot figure out, when "Service Quote" is selected, the macro saves it into the "Service Reports" folder. I have triple-checked the filepath. I don't understand? Can anyone see something I am missing here? I won't pretend to be good at this, yet. Thank you very much if you can tell me where I've gone wrong.

[davesexcel]

I don't think changing the directory automatically means the workbook will save in that directory.
A path is required.
For example using the macro recorder.

Please Login or Register  to view this content.

This will produce the same effect

Please Login or Register  to view this content.

Changing the directory is not required

[Greg M]

Hi there,

I'm not a great believer in using the ChDir command, and prefer to use a fully-qualified filename when saving a file.

Try the following code and see if it does what you require:

Please Login or Register  to view this content.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[kirsty]

Thank you for your help! I rewrote the code, eliminating the ChDir command based on the codes provided and it is working properly now as far as I can tell. Thank you again!