Close Workbook from Macro

[Lou]

I have workbook A.xls in which I run a macro that will
import a text file (B.txt) and save it as B.xls.

Can I incorporate a statement in my macro in A.xls that
will close A.xls at the end?

TIA.

 

[Guest]

If you want to save before close
Thisworkbook.Close Tru

if you want the workbook close without save
Thisworkbook.Close Fals

Regards
(e-mail address removed)
http://www.vonixx.co


----- Lou wrote: ----

I have workbook A.xls in which I run a macro that will
import a text file (B.txt) and save it as B.xls

Can I incorporate a statement in my macro in A.xls that
will close A.xls at the end

TIA

 

[mudraker]

Lou

Just include this as your last line of code


Workbooks(ThisWorkbook.Name).Close SaveChanges:=Fals