Does VBA have the sendkey function??

[LyviaChung]

Is the VBA of Excel have "SendKey" function?

I create a bottom, when I click it, it will save the file to HTML and XLS format.
Because the file is already exist, so the system will prompt message about save it or not. I'd like to auto answer it "Yes".
But I don't know how to do it.
The code I use is
ActiveWorkbook.SaveAs filename:=Target,fileformat=xlHTML

 

[Ivan F Moala]

Yes VBA has sendkeys
Press F1 while in the VBE editor and type
in sendkeys to read all about it.
You can't use send keys in this situation.

Try application.displayalerts=false
just before the saveas.


Ivan