Save and Close to a specific folder

Hi I have the code below that is working fine but ever now and then it will save in a random folder on one of our many shared drives.

How do i get it to save to a specific folder very time.

Thanks in advance

Code:

Please Login or Register  to view this content.

If you want to save in the same place every time, then you can use the active path.

Maybe this will help you get started

Please Login or Register  to view this content.

It all depends on what you are tying to do. Maybe a little bit more explanation on what you are trying to achieve?

I think we'll need more information.

Please Login or Register  to view this content.

That should save the file in the same place it was opened from, not in a new (or random location).

It is possible that you have code somewhere else that is causing the issue. What is the code for Sub RO_Close?

Is there a SaveAs method call anywhere in your existing code?

It would help if you could share the file so we can see all the code. The paper clip icon does not work for attachments. To attach a file, under the text box where you type your reply click the Go Advanced button. On the next screen scroll down and click on Manage Attachments, which will show a pop-up window to Select and Upload a file. Then close the window.

Agree with 6SJ: given the code presented, you would expect it to save in the same place. UNLESS, you have code elsewhere that changes the Active Workbook. Note that the ActiveWorkbook is not necessarily the same as ThisWorkbook. ThisWorkbook is the workbook running the code.

Or, maybe another user opens another workbook or two so the ActiveWorkbook is not what you think it is ... but that would maybe closing the wrong workbook, not saving yours in the wrong place ... just thinking out loud

I see only one reference to ActiveWorkbook and it is to protect sheet Master1 (that should be changed to ThisWorkbook, but it isn't causing your problem). I don't see anyplace where another file is created or opened.

I'm going to see if I can do any testing with your file. Not sure what will happen with stuff missing.