![]() |
saving excel file as tab delimited text programmatically
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 |
All times are GMT +1. The time now is 10:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com