And I can't figure out why!! I did ask this on MrExcel with no real response.
Help!! Thanks and Hi, Ken!
Yes, I have rights to root.
The file format is xlsm before saving. I don't *need* a macro-free workbook, I just need xls so the SQL that's going to use the data works right.
Code:
Sub SaveForImporting()
ThisWorkbook.SaveAs "C:\MImport" & ".xls", FileFormat:=56
ActiveWorkbook.Close False
End Sub
Help!! Thanks and Hi, Ken!
Yes, I have rights to root.
The file format is xlsm before saving. I don't *need* a macro-free workbook, I just need xls so the SQL that's going to use the data works right.
Last edited: