VBA save as and save Urgent please.... Thanks

[zubair009]

Hi Everyone,
i would appreciate for this, I require a vba when I save it should just save the file and when i press Save As it should run some procedure and prompt a dialogue to Save As file.

Thank you in advance.

 

[Michael M]

Why do you need VBA ??
Save and SaveAs already work as you have requested......EXCEPT for the very first time it is saved, when the workbook is still caleed Book1, Book2 etc !!

 

[zubair009]

Thanks for your reply,
i agree it is working provided if you don't run any procedure during save. if you add any procedure in before save then it always run whether you want to save or save as it always run. i need a vba when i press that procedure should not run which i have it in before save and it should just save file but when i press save as then it should ask a file by running that procedure.

on Save system should just save file
on Save As system should run before save event and then ask for savging file.

This is how i have requested if you can help.

 

[Michael M]

It would help if you posted what code you already have !