+ Reply to Thread
Results 1 to 2 of 2

Assistance with web lookup pulling result of zip code input

  1. #1
    Registered User
    Join Date
    05-08-2018
    Location
    Florida, USA
    MS-Off Ver
    Mac 16.12
    Posts
    2

    Question Assistance with web lookup pulling result of zip code input

    Hi all and thank you in advance for any assistance. I'm in over my head on a project and looking for some help/guidance.

    I want to pull information from a website based upon the information input into my worksheet.
    A1 = OriginZip
    A2 = DestinationZip
    A3 = Zone

    When zip codes are entered in to B1 and B2, run the vba script to this url (forum wont let me post URL, so google "find fedex zone" and click the top result) entering the zip codes and retrieving and entering the resulting zone in B3.

    Any help or guidance would be greatly appreciated. I'm not terribly familiar with the visual basic editor but I know how to navigate to it and know some basics. Using mac with Excel up to date version 16.12

  2. #2
    Registered User
    Join Date
    05-08-2018
    Location
    Florida, USA
    MS-Off Ver
    Mac 16.12
    Posts
    2

    Re: Assistance with web lookup pulling result of zip code input

    I'm using this youtube video as a guide but the issue I'm running into is the page I'm trying to pull from does not allow me to enter a URL like ..?origzipcd=xxxxx
    youtube video name = "Excel VBA Pull Data From A Website"

+ 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. Assistance with searching text and pulling info from it
    By AceForSale in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-16-2016, 12:15 PM
  2. Replies: 1
    Last Post: 09-11-2016, 07:40 PM
  3. [SOLVED] VBA Code assistance to populate textbox with lookup sales total via date pickers
    By sintek in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 08-11-2016, 09:30 AM
  4. Replies: 12
    Last Post: 12-23-2015, 03:13 PM
  5. Assistance needed to loop code when pulling info from a web page and pasting to excel
    By boswelljw in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2015, 09:49 AM
  6. need assistance with some find or lookup related code...
    By hshayh0rn in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-03-2006, 07:10 PM
  7. Pause code, wait for input, no input received, carry on with the code
    By johnd@arm.co.uk in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-29-2005, 08:05 AM

Tags for this Thread

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