dumb question

F

ForSale

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
 
F

Frank Kabel

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

Tom Ogilvy

Yes, but why not just do

Thisworkbook.Save

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

ForSale

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
 
T

Tom Ogilvy

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.
 
Top