LyviaChung
New Member
- Joined
- Feb 19, 2002
- Messages
- 2
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
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