Save wrkbook in current location instead of specific path.

[jassybun]

I have a macro that saves the file in a specific drive location. However the drive is named differently on everyone's computer that has the network mapped (V vs X, et). So If I wanted to change this bit of macro to save in the same location as the original file which is always in the right location, how would I change this?

ThisWorkbook.SaveAs "V:\Comp\Manager\Report"

 

[Marc L]

ThisWorkbook.SaveAs ThisWorkbook.Path & "\Report" …​

​

 

[jassybun]

Thank you!