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

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?
 
D

Don Guillett

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
 
T

Tony

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?
 
Top