Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Why am I getting an error1004 every time I run a macro through a website? | Excel Discussion (Misc queries) | |||
Macro to search a website from a cell | Excel Worksheet Functions | |||
How do I create a macro that pulls stock prices from a website? | Excel Discussion (Misc queries) | |||
I want few website name for macro | New Users to Excel | |||
How can I link from an external website to a particular worksheet | Excel Worksheet Functions |