B
Brian McCullough
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
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