saving excel file as tab delimited text programmatically

P

Philip

i'm using the following script to save the excel file as tab delimited text.
although the file it produces and the manually saved file seems to be
similar they are slightly different when i compare them by fc.exe even their
sizes equal. i am using office 2002 English, there is an issue reported for
office 2000 in microsoft site but nothing about this one. is it really an
issue or what should i do to get the similar effect for programmatic save?

Dim objXL
Set objXL = WScript.CreateObject("Excel.Application")
'
' open file
'
objXL.Workbooks.Open("C:\d.xls")
'objXL.Visible = true

'close workbook AFTER saving
objXL.DisplayAlerts = False 'disable the overwrite? prompt, JUST DO IT
objXL.ActiveWorkbook.SaveAs "C:\d.txt", -4158
objXL.Workbooks.Close
objXL.DisplayAlerts = True 'reenable prompts
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

can't print excel sheet using wsh script 1
Closing Excel from Script 2
Passing string as macro parameter 1
Japanese text lost when save as tab delimited text file 0
Save As xls to text (tab delimited) in encoding utf-8 0
Need help saving as tab-delimited file 1
Problem when Excel Not Maximized 2
Converting Tab Delimited Text File to A Comma Delimited Text File 1

Top