removing "do you want to save..."
 

I have a macro that opens a test file, then modifies it & copies the
modified file to my spreadsheet. I am then through with the text file
and want to close it in my macro. When I go to close it in my macro, I
get the dialog asking me if I want to keep my changes. I do not want to
keep my changes. Is there a command I can use so that this dialog will
not display and I can just ignore my changes on the text file & close
it?


--
mwc0914
------------------------------------------------------------------------
mwc0914's Profile: http://www.excelforum.com/member.php...o&userid=24130
View this thread: http://www.excelforum.com/showthread...hreadid=552725

removing "do you want to save..."
 

File1.Close False
The false means don't save

HTH

Die_Another_Day
mwc0914 wrote:
I have a macro that opens a test file, then modifies it & copies the
modified file to my spreadsheet. I am then through with the text file
and want to close it in my macro. When I go to close it in my macro, I
get the dialog asking me if I want to keep my changes. I do not want to
keep my changes. Is there a command I can use so that this dialog will
not display and I can just ignore my changes on the text file & close
it?


--
mwc0914
------------------------------------------------------------------------
mwc0914's Profile: http://www.excelforum.com/member.php...o&userid=24130
View this thread: http://www.excelforum.com/showthread...hreadid=552725