HOW 2>> Auto Close and Save CSV file

's Computer Specifications

Hi, all... I am trying to copy some values into a CSV file then close and
save both files. When I use ActiveWindow.save or ActiveWindow.Close on the
CSV file it prompts my if I want to save it as is, and OF COURSE I DO...
How can I accomplish this with out the prompts??? Thank you again....

's Computer Specifications

Application.DisplayAlerts=False

"WANNABE" wrote:

> Hi, all... I am trying to copy some values into a CSV file then close and
> save both files. When I use ActiveWindow.save or ActiveWindow.Close on the
> CSV file it prompts my if I want to save it as is, and OF COURSE I DO...
> How can I accomplish this with out the prompts??? Thank you again....
>
>
>

's Computer Specifications

AWESOME!!!!! THANK YOU VERY MUCH!!!!
"Alok" <(E-Mail Removed)> wrote in message
news:C090FC00-6D96-4727-AE87-(E-Mail Removed)...
> Application.DisplayAlerts=False
>
> "WANNABE" wrote:
>
>> Hi, all... I am trying to copy some values into a CSV file then close
>> and
>> save both files. When I use ActiveWindow.save or ActiveWindow.Close on
>> the
>> CSV file it prompts my if I want to save it as is, and OF COURSE I DO...
>> How can I accomplish this with out the prompts??? Thank you again....
>>
>>
>>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Auto save and close	Frank	Microsoft Excel Worksheet Functions	0	19th Nov 2009 10:50 AM
Auto-save on close	=?Utf-8?B?U3RoT3pOZXdiaWU=?=	Microsoft Excel Programming	8	26th Feb 2007 05:31 PM
Auto Open file VBA Refresh MS Query Save Close	gcutter	Microsoft Excel Programming	2	26th Sep 2005 03:07 PM
Auto Excel workbook close: save= false during an auto subroutine	=?Utf-8?B?dG9td2FzaGVyZTI=?=	Microsoft Excel Programming	10	16th Jun 2005 06:23 AM
Auto Close and Save	scottwilsonx	Microsoft Excel Programming	3	7th Jul 2004 11:09 AM