Jump to content
Macro Express Forums

Is There A Solution For My Address Finder Macro?


chriz1000
 Share

Recommended Posts

I’m trying to make a macro that copy’s the house number and postcode from a MS Access form, then opens up this website: http://www.postoffice.co.uk/portal/po/addr...requestid=89894

And pastes the house number and postcode into the relative fields. I have done this bit so far, but it’s probably not done in the most efficient way.

What I then need to do is copy the returned address results from the website above back into the access form. This is what I’m having problems doing.

 

Any help much appreciated.

 

Chris

Link to comment
Share on other sites

Have you tried something like this?

  • Highlight the result on the web page ("the returned address results")
  • Copy to the clipboard
  • Switch back to Access
  • Move to the correct field in Access
  • Paste

Or, if the result (on the web page) consists of more than one value:

  • Highlight part of the result on the web page
  • Copy to the clipboard
  • Copy from the clipboard to a variable (T10)

  • Highlight another part of the result on the web page
  • Copy to the clipboard
  • Copy from the clipboard to another variable (T11)

  • Repeat as necessary

  • Switch back to Access
  • Move to the correct field in Access
  • Text type variable (T10)

  • Move to the next field in Access
  • Text type variable (T11)

  • Repeat as necessary

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

×
×
  • Create New...