Close Excel without saving using VBA

's Computer Specifications

Guys,
I am refreshing Excel WSheet throught Access and after I
am done - I need NOT to save changes to a Workbook.

I also want NOT to see a message wich asks whether I want
to save changes.

Know How ???

Thanks
TIA

's Computer Specifications

>-----Original Message-----
>Guys,
>I am refreshing Excel WSheet throught Access and after I
>am done - I need NOT to save changes to a Workbook.
>
>I also want NOT to see a message wich asks whether I want
>to save changes.
>
>Know How ???
>
>Thanks
>TIA
>.Try ActiveWorkbook.close = false

>

's Computer Specifications

Excel.Application.Workbooks("WorkbookName").Save False

--
Ken Snell
<MS ACCESS MVP>

"TIA" <(E-Mail Removed)> wrote in message
news:1a22d01c38782$2b330cd0$(E-Mail Removed)...
> Guys,
> I am refreshing Excel WSheet throught Access and after I
> am done - I need NOT to save changes to a Workbook.
>
> I also want NOT to see a message wich asks whether I want
> to save changes.
>
> Know How ???
>
> Thanks
> TIA

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Cannot close Excel without saving	jstonend@gmail.com	Microsoft Excel Discussion	0	12th Jan 2007 07:35 PM
How can I get an excel macro to close without saving !	Roger O	Microsoft Excel Programming	4	21st Sep 2005 04:21 PM
close excel without saving	=?Utf-8?B?TWlrZQ==?=	Microsoft Excel Programming	11	24th Jun 2005 04:08 PM
Auto close excel without saving	John Haywood	Microsoft Excel Programming	0	23rd Aug 2004 09:00 PM
Excel Macro to Close Without Saving	Kass	Microsoft Access Macros	2	27th Jan 2004 01:35 PM