saving an excel sheet in a the current directory with VBA - Stack Overflow

VBA has a CurDir keyword that will return the "current directory" as stored in Excel. I'm not sure all the things that affect the current directory, but definitely opening or saving a workbook will change it. MyWorkbook.SaveAs CurDir & Application.PathSep

stackoverflow.com