View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
AA2e72E[_2_] AA2e72E[_2_] is offline
external usenet poster
 
Posts: 93
Default Save as .txt then close

How does it not work? Does it appear to do nothing or does it prompt you to do something else

I suspect it might be the latter. Try setting the saved property to true before closing

ActiveWorkbook.Saved = Tru
ActiveWorkbook.Clos

set WorkbookObject = Nothing ' this is your object