Results 1 to 2 of 2

Thread: Web query VBA

  1. #1
    2 Star Lounger
    Join Date
    Jun 2011
    Posts
    188
    Thanks
    62
    Thanked 0 Times in 0 Posts

    Web query VBA

    Hello Experts!

    i need to automate the web query on password prompt and use static URL. When site open in New query ( i can select the dates of data manually in our website). Then click to import button in web query ( get external data )?

    Thanks

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    I think it requies the use of SENDKEYS. Check out the code at http://www.mrexcel.com/forum/excel-q...-password.html

    Steve

Posting Permissions

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