Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
How to "Save As" in Excel 2003 and change file format
#1
I am trying to save the active workbook in excel 2003 using Save As and changing file format to Text Tab Delimited. Is there a simple way to do this?
#2
In a prior post was:

";es.Save(filename) ;;does not change file format"
#3
Macro Macro1555
Code:
Copy      Help
es.ws.Application.ActiveWorkbook.SaveAs(filename Excel.xlCSV @ @ @ @ 1)

xlCSV is file format. Also can be used these formats:
http://msdn.microsoft.com/en-us/library/ff198017.aspx


Forum Jump:


Users browsing this thread: 1 Guest(s)