SaveAs Directory Changing

[dusto]

I have a macro that I run that formats a csv file and I would like to output a xlsx file. I'm using this SaveAs

Please Login or Register  to view this content.

My problem is when I use the above code, my msgbox shows: (which i think is due to pre-existing macros my company uses in excel.)

Please Login or Register  to view this content.

However, the files are actually saved in

Please Login or Register  to view this content.

How to I get the actual location of the csv file instead of the one that thisworkbook.path returns?

[dusto]

is there another way to grab the path?