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
|