LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default 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


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Saving as text(tab delimited) file Pam New Users to Excel 1 November 4th 09 01:30 AM
Saving a tab delimited txt file Hacks New Users to Excel 0 October 13th 06 02:20 PM
Saving Excel sheet as a semicolon delimited file (.csv) e_dog95 Excel Discussion (Misc queries) 1 February 18th 06 11:02 PM
saving file as text(tab delimited)... Sevgi Excel Discussion (Misc queries) 1 April 6th 05 07:04 PM
saving excel file as tab delimited Craig Hilliard Excel Discussion (Misc queries) 0 February 1st 05 10:39 PM


All times are GMT +1. The time now is 10:21 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"