prompt when saving as .txt (Tab delimited) format?
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 |
prompt when saving as .txt (Tab delimited) format?
I have not had experiencre with this type of problem but try Application.DisplayAlerts = False objWorkSheet.SaveAs sSavePath & SaveName & ".txt", xlText, , , , False Application.DisplayAlerts = True or on error resume next objWorkSheet.SaveAs sSavePath & SaveName & ".txt", xlText, , , , False on error goto ----------------------------------------------- ~~ Message posted from http://www.ExcelTip.com ~~View and post usenet messages directly from http://www.ExcelForum.com |
prompt when saving as .txt (Tab delimited) format?
An object defined error means
objWorksheet does not reference an object. it doesn't have anything to do with that prompt. -- Regards, Tom Ogilvy Brian McCullough wrote in message ... 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 |
All times are GMT +1. The time now is 11:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com