What I want to do is make a path.ini or path.config file where the user can enter the path of a folder where he or she wants the output files to be placed. Something like this I think ?
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
Than in the path.ini file the user can alter the path like:
C:\Program Files (x86)\myScript Folder\Files\
and where I have ChDir = sPath will use the path from the ini file to drop the file into that folder. I can't hard code the path because some of the users won't always be connected to the network and I need them to be able to set the path so they can upload or email the file to us.