E
Emma Hope
We use a website to enter data to a fellow company and
every so often we have to go into status report pages and
copy out all the data into Excel.
We go into the page, type in a reference number into a
box, press go and it then takes us to another page, which
we copy and paste into Excel.
What i would like to do is write a macro to press a
hyperlink to open the webpage (no problem), copy the
reference number from Excel (also no problem), then tab to
the relevant field on the web page, copy in the reference,
press enter (so that it goes to the next page), then
selects all, copies it and then pastes it back into the
Excel sheet, it is the bit where you move into Internet
Explorer that doesn't work.
Can anyone help?
Thanks
Emma
every so often we have to go into status report pages and
copy out all the data into Excel.
We go into the page, type in a reference number into a
box, press go and it then takes us to another page, which
we copy and paste into Excel.
What i would like to do is write a macro to press a
hyperlink to open the webpage (no problem), copy the
reference number from Excel (also no problem), then tab to
the relevant field on the web page, copy in the reference,
press enter (so that it goes to the next page), then
selects all, copies it and then pastes it back into the
Excel sheet, it is the bit where you move into Internet
Explorer that doesn't work.
Can anyone help?
Thanks
Emma