Can I go to a website using a macro in a worksheet?

  • Thread starter Thread starter Tony
  • Start date Start date
T

Tony

We do a lot of repetitive entry into several different websites, but most of
the information is the same but maybe in different spots on each individual
website...i.e. name, address, etc.

Can I design a form on page one to enter all of this information and then on
sheet 2 design a macro to take the info on sheet 1 and copy and paste into a
website?
 
Most definitely. I do this for clients all the time.
click on the tables to import> right click>import to msexcel>Once you have
it record a macro to refresh while you go into data>import external
data>edit query>etc
 
Ok, i understood the "most definately". From there you pretty much lost me.
What I am talking about here is an auto insurance quote. Each company uses
the data that we would enter in a different sequence for their own individual
website. I'm not sure what you mean by tables to import...I assumed that I
would need to copy and paste each specific bit of info one field at a time to
make sure that it gets placed in the appropriate place on the company site.
Where do I learn more about all of this and how to do it? I am thinking of
taking a fred pryor seminar in hopes that this would help me learn it...any
thoughts?
 
Post a couple of urls and/or send me a workbook to the address below.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top