Save file works, but not it the right folder

[kevin071572]

I'm winging my way trying to learn VBA but I can't find the answer to this problem. I have a macro that renames the current file and saves a copy with a new file name based of the value of 3 different cells. But it doesn't save it in the same folder that it opened from. I can't just copy the code to here since it's on a private network that doesn't access the internet. It uses the line & CurDir & "\" MyCell & ".xls"

That line doesn't save it in the folder the file started from. Am I missing something to complete the path to the file? Am I even asking the right question?

 

[Norie]

Don't use CurDir, that returns the current directory not the workbooks path.

You could probably use it sometimes as the current directory could be the same as the workbook's path but that would be a bit (lot) hit and miss.

Use ThisWorkbook.Path.

 

[Jonmo1]

change

& CurDir & "\" MyCell & ".xls"

to

& "C:\ActualCompletePath\" & MyCell & ".xls"

 

[kevin071572]

change

& CurDir & "\" MyCell & ".xls"

to

& "C:\ActualCompletePath\" & MyCell & ".xls"

Thanks, but the folder will change every month and I'm setting this up for our replacements in a couple months.

I'll try the ThisWorkbook.Path in a couple minutes
Thanks for your help