+ Reply to Thread
Results 1 to 7 of 7

IE automation

  1. #1
    Registered User
    Join Date
    06-17-2012
    Location
    Australia
    MS-Off Ver
    MS Office 365
    Posts
    40

    Question IE automation

    Hi am having issues referencing an input field using VBA Automation.

    This is the source data, unfortunately its on a intranet so I cant post a link, I know that will limit the ability for assistance.
    HTML Code: 
    I get no error from the below however it populates no value at all.

    This is the VBA code:
    Please Login or Register  to view this content.
    Variables dimmed per below:

    Please Login or Register  to view this content.
    Thanks for any assistance.

  2. #2
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: IE automation

    Hi,
    Your code seems correct and you are right this way I can't help you too much.
    Could you use appIE.Document.body.innertext and check requested data is appearing...
    Lokesh Kumar
    Stay Hungry.. Stay Foolish..
    _________________________________________________________
    Please Click STAR to Add Reputation if my/someone's answer helped!

  3. #3
    Registered User
    Join Date
    06-17-2012
    Location
    Australia
    MS-Off Ver
    MS Office 365
    Posts
    40

    Re: IE automation

    Hi,

    Thats interesting your point, thanks :-)

    I cant try until I am at work tomorrow, will update then. Cheers.

  4. #4
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: IE automation

    Great....
    I have done web scrapping a lot.

  5. #5
    Registered User
    Join Date
    06-17-2012
    Location
    Australia
    MS-Off Ver
    MS Office 365
    Posts
    40

    Re: IE automation

    I have tried the code and I get nothing returned, I get no error however.

  6. #6
    Forum Contributor
    Join Date
    04-20-2015
    Location
    Switzerland
    MS-Off Ver
    2010
    Posts
    312

    Re: IE automation

    cause its in the intranet try to change the following
    That often solved problems i had with intranet sites

    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.
    and

    Please Login or Register  to view this content.
    to
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    04-20-2015
    Location
    Switzerland
    MS-Off Ver
    2010
    Posts
    312

    Re: IE automation

    Did that work for you?
    or did you find another solution?
    Would be nice if you give an update for other users that face the same problem if you solved this

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Web Automation
    By shivu98 in forum Hello..Introduce yourself
    Replies: 2
    Last Post: 09-22-2014, 07:53 AM
  2. need help with Vba IE automation
    By colonna in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-28-2013, 06:46 AM
  3. IE Automation
    By efernandes67 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-07-2011, 01:45 PM
  4. Automation using VBA
    By kingfisher007 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-24-2008, 07:29 AM
  5. VBA for Automation
    By joone in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-05-2007, 02:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1