Your question, your audience. Choose who sees your identity—and your question—with question security.
Dim objFSO As Object, objFolder As Object, objFile As Object Dim sPath As String sPath= "C:\Program Files (x86)\myScript Folder\path.ini" ChDir = sPath ActiveWorkbook.SaveAs fileName:="Sample" & Format(Date, "_mm.dd.yyyy.") & "xls", FileFormat:=xlText ActiveWorkbook.Saved = True ActiveDocument.Close
Join the community of 500,000 technology professionals and ask your questions.