Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
All,
I am scripting/programming Excel XP and I am trying to save a worksheet as ..txt (Tab delimited). Here is my code which lives in a VB application: objWorkSheet.SaveAs sSavePath & SaveName & ".txt", xlText, , , , False I keep getting an application / object defined error when i run this line of code. I attempted to do the equivalent manually and i found that i am getting a dialog that states: FileName.txt may contain features that are not compatible with Text (Tab delimited). Do you want to keep the workbook in this format? * To keep this format, which leaves out any incompatible features, click Yes. * To preserve the features, click No. Then save a copy in the latest Excel format. * To see what might be lost, click Help. Through script/code, how do i prevent this message from appearing or attempting to appear?? My Excel application object's Visible property is set to false... Thanks!!!! Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving Excel data in tab delimited format to Notepad | Excel Discussion (Misc queries) | |||
Saving as tab delimited or comma delimited | Excel Discussion (Misc queries) | |||
Saving a tab delimited txt file | New Users to Excel | |||
saving excel file as tab delimited | Excel Discussion (Misc queries) | |||
Need help saving as tab-delimited file | Excel Programming |