Thread: prompt when saving as .txt (Tab delimited) format?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
mudraker[_24_] mudraker[_24_] is offline
external usenet poster
  
Posts: 1
Default 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

Reply With QuoteReply With Quote