Does VBA have the sendkey function??
Upcoming Power Excel Seminars
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Does VBA have the sendkey function??

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    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

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    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

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com