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

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?

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

Most definitely. I do this for clients all the time.
click on the tables to import right clickimport to msexcelOnce you have
it record a macro to refresh while you go into dataimport external
dataedit queryetc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tony" wrote in message
...
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?

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

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?

"Don Guillett" wrote:

Most definitely. I do this for clients all the time.
click on the tables to import right clickimport to msexcelOnce you have
it record a macro to refresh while you go into dataimport external
dataedit queryetc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tony" wrote in message
...
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?

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

Post a couple of urls and/or send me a workbook to the address below.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tony" wrote in message
...
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?

"Don Guillett" wrote:

Most definitely. I do this for clients all the time.
click on the tables to import right clickimport to msexcelOnce you
have
it record a macro to refresh while you go into dataimport external
dataedit queryetc

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Tony" wrote in message
...
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?