i feel i should know the answer, but i can't think of it for som
reason. when saving as, how do i save get it to save over the origna
file without displaying the alert message

--
Message posted from http://www.ExcelForum.com

Hi
'...
application.displayalerts=false
activeworkbook.saveas "filename.xls"
application.displayalerts=True
'...

--
Regards
Frank Kabel
Frankfurt, Germany

"ForSale " schrieb im
Newsbeitrag ...
i feel i should know the answer, but i can't think of it for some
reason. when saving as, how do i save get it to save over the
orignal
file without displaying the alert message?


---
Message posted from http://www.ExcelForum.com/

and this will force the answer of 'yes' when it asks to save over a
existing file

--
Message posted from http://www.ExcelForum.com

Yes, but why not just do

Thisworkbook.Save

You don't need saveas unless you are changing the filename (which apparently
you are not).

--
Regards,
Tom Ogilvy

"ForSale " wrote in message
...
and this will force the answer of 'yes' when it asks to save over an
existing file?


---
Message posted from http://www.ExcelForum.com/

Actually, i am. i have one workbook that kind of acts like a template.
in it, the macro saves the workbook to save any changes that i've made
then pastes from the clipboard, saves it as range("b2") which is th
same 15 items everyday, so rather than making 15 new files everyday,
just save over yesterdays as yesterdays are old hat by today. then i
does lots of other stuff including e-mailing and closing the new save
as file, then re-opening the template file.
the only problem i've run into thus far was having to stop and push Ye
on the save as existing file pop up, and of course having to run th
same 15 files everyday. it's not hard, just takes a long time for al
the saving and pasting. i don't guess there's a way to program VBA t
run other applications that aren't microsoft programs

--
Message posted from http://www.ExcelForum.com

it they are COM, then you can use oleautomation

if not, then you can use the vba shell command. - but you will have no
control of it - just start it.

--
Regards,
Tom Ogilvy

"ForSale " wrote in message
...
Actually, i am. i have one workbook that kind of acts like a template.
in it, the macro saves the workbook to save any changes that i've made,
then pastes from the clipboard, saves it as range("b2") which is the
same 15 items everyday, so rather than making 15 new files everyday, i
just save over yesterdays as yesterdays are old hat by today. then it
does lots of other stuff including e-mailing and closing the new saved
as file, then re-opening the template file.
the only problem i've run into thus far was having to stop and push Yes
on the save as existing file pop up, and of course having to run the
same 15 files everyday. it's not hard, just takes a long time for all
the saving and pasting. i don't guess there's a way to program VBA to
run other applications that aren't microsoft programs?


---
Message posted from http://www.ExcelForum.com/