I have a VBA macro that creates and saves a new workbook in the same path than the original file. I use this command in VBA to know the current path: "Application.ThisWorkbook.Path"
It works fine in the Excel File but not in the compiled file (it saves it in a hidden Windows directory). Do you know what do I have to do to create and save a workbook in the EXE file path? Thanks.
I have answered my question with another post:
Public Function PathToFile(Filename As String)
Set XLSPadlock = Application.COMAddIns(“GXLSForm.GXLSFormula”).Object
PathToFile = XLSPadlock.PLEvalVar(“EXEPath”) & Filename
End Function