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

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

瀏覽:935
日期:2025-05-06
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...看更多