Copy and paste from ie to excel using macro

[Larry Sartoris]

I'm trying to copy information from internet explorer into excel. There's a
lot of info on different pages so I was wondering if this was possible?

Basically the website has a search function. I have all the searches I need
in excel right now. Right now I'm copying the search item into the search
window and then hitting enter then copying a description of the item and then
copying that into excel. Then I'm going back to the search bar and entering
another search item.

Does this make sense? Is there a way to write this as a macro? I'm
familiar with making macros but I've always stayed within excel.

Thanks for any help

[Larry Sartoris]

bump!

"Larry Sartoris" wrote:

> I'm trying to copy information from internet explorer into excel. There's a
> lot of info on different pages so I was wondering if this was possible?
>
> Basically the website has a search function. I have all the searches I need
> in excel right now. Right now I'm copying the search item into the search
> window and then hitting enter then copying a description of the item and then
> copying that into excel. Then I'm going back to the search bar and entering
> another search item.
>
> Does this make sense? Is there a way to write this as a macro? I'm
> familiar with making macros but I've always stayed within excel.
>
> Thanks for any help

[Tim Williams]

Do a view-source and find the "<form...>" tag: is the "method" GET or POST?
Default (if none stated) is GET.
If it uses GET you should be able to see your search terms in the browser
address bar.


Tim.

--
Tim Williams
Palo Alto, CA


"Larry Sartoris" <[email protected]> wrote in message
news:[email protected]...
> bump!
>
> "Larry Sartoris" wrote:
>
> > I'm trying to copy information from internet explorer into excel.
There's a
> > lot of info on different pages so I was wondering if this was possible?
> >
> > Basically the website has a search function. I have all the searches I
need
> > in excel right now. Right now I'm copying the search item into the
search
> > window and then hitting enter then copying a description of the item and
then
> > copying that into excel. Then I'm going back to the search bar and
entering
> > another search item.
> >
> > Does this make sense? Is there a way to write this as a macro? I'm
> > familiar with making macros but I've always stayed within excel.
> >
> > Thanks for any help

[Larry Sartoris]

<form action="/search/search.asp" method="POST" name="theForm">

you're referring to this?

I'm thinking that it's POST. What now?

"Tim Williams" wrote:

>
> Do a view-source and find the "<form...>" tag: is the "method" GET or POST?
> Default (if none stated) is GET.
> If it uses GET you should be able to see your search terms in the browser
> address bar.
>
>
> Tim.
>
> --
> Tim Williams
> Palo Alto, CA
>
>
> "Larry Sartoris" <[email protected]> wrote in message
> news:[email protected]...
> > bump!
> >
> > "Larry Sartoris" wrote:
> >
> > > I'm trying to copy information from internet explorer into excel.
> There's a
> > > lot of info on different pages so I was wondering if this was possible?
> > >
> > > Basically the website has a search function. I have all the searches I
> need
> > > in excel right now. Right now I'm copying the search item into the
> search
> > > window and then hitting enter then copying a description of the item and
> then
> > > copying that into excel. Then I'm going back to the search bar and
> entering
> > > another search item.
> > >
> > > Does this make sense? Is there a way to write this as a macro? I'm
> > > familiar with making macros but I've always stayed within excel.
> > >
> > > Thanks for any help
>
>
>