Puddles1
09-25-2014, 09:47 AM
Hello!
This is not saving as an Excel file or saving to the path specified (or anywhere that I can tell). And I am not getting any erros and it seems to be working but when I go to look for the file it isn't there.
ChDir "G:\xxxx\Maintenance\Logging"
Dim FName As String
FName = Application.GetSaveAsFilename("G:\xxxx\Maintenance\Logging""ExcelFile,(*.xlsx),*,.xlsx")
FileFormat = xlOpenXMLWorkbook
This is not saving as an Excel file or saving to the path specified (or anywhere that I can tell). And I am not getting any erros and it seems to be working but when I go to look for the file it isn't there.
ChDir "G:\xxxx\Maintenance\Logging"
Dim FName As String
FName = Application.GetSaveAsFilename("G:\xxxx\Maintenance\Logging""ExcelFile,(*.xlsx),*,.xlsx")
FileFormat = xlOpenXMLWorkbook