Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving as text(tab delimited) file | New Users to Excel | |||
Saving a tab delimited txt file | New Users to Excel | |||
Saving Excel sheet as a semicolon delimited file (.csv) | Excel Discussion (Misc queries) | |||
saving file as text(tab delimited)... | Excel Discussion (Misc queries) | |||
saving excel file as tab delimited | Excel Discussion (Misc queries) |