make a command after a delay

[samvelt]

Hi,

after running such command
ActiveWorkbook.SaveAs ActiveWorkbook.Path & "\" & sFilename
I have to press yes (or enter) which I would like to write in vba.

As far as I remember there was a command in VBA to run a command after some delay.
How to call Application.OnKey "~" command with a second delay before calling .SaveAs command?

Thanks,
Sam

[Marc L]

Hi,

bad way but better is to disable DisplayAlerts property …

[samvelt]

Thanks, nicely works