Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 313
Default 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?
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default 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?


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 313
Default 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?



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10,124
Default 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?




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why am I getting an error1004 every time I run a macro through a website? SAM SEBAIHI Excel Discussion (Misc queries) 0 February 14th 07 03:22 AM
Macro to search a website from a cell Dileep Chandran Excel Worksheet Functions 2 November 13th 06 04:46 AM
How do I create a macro that pulls stock prices from a website? Mikey Excel Discussion (Misc queries) 1 July 19th 06 11:56 PM
I want few website name for macro irsath New Users to Excel 2 July 2nd 06 01:00 PM
How can I link from an external website to a particular worksheet Zircom Excel Worksheet Functions 0 May 5th 06 04:30 PM


All times are GMT +1. The time now is 07:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"