macro to let excel save silently not asking or prompting anything

[Ph0nix]

Hi guys

Please help have been browsing for ages I think the reason why i cant find the answer for my question is because if the excel version but cant find any excel 2010 answers:

What im trying to do is, after my macro did all its calculations i want it to save silently let it save to a specific location as a specific format i already got the location and the name covered i think i got the type covered (i want it to save as a normal excel sheet macros disabled) so basically all that i need is for it do to all of this without prompting anything from me. I want to run this from a .bat file and if the excel sheet prompt me for a response its kinda useless here is my save sub :

Please Login or Register  to view this content.

O yes and i'm using excel 2010

Thnx in advance guys.

[johnjohns]

perhaps

Please Login or Register  to view this content.

before saving

[royUK]

Try this

Please Login or Register  to view this content.