Help with Click link, Find, Paste (Excel to Web back to Excel)
 

All,
I hope someone has done something like this in the past.

I'm attempting to import my trouble ticket information from a vendors
site.

I've created a Excel doc that has
Ticketnumber (Link)
Date open
Status
Open by

I've added another column
for
Problem description
Resolution description.
What I need to do is
For each item in column A follow link
On the webpage that is given locate the word "Problem Description:"
Copy all text between "Problem Description:" and Problem Resolution:
and paste into my excel doc in the same row under "Problem description"

The vendor's site requires me to login - I don't mind storing my login
infomation within the excel doc.

Any thought?
Steve

Help with Click link, Find, Paste (Excel to Web back to Excel)
 

according to my understand what you are trying to do is to connect to a link
using url and get the ticket informaiton into excel file.
it is possible , please use XMLHTTP object and follow Post method to login,
retrieve the information in any form and paste it into excel.

you can find lot of stuff on net.

here is url for your help

http://www.15seconds.com/issue/991125.htm

"Steve" wrote:

All,
I hope someone has done something like this in the past.

I'm attempting to import my trouble ticket information from a vendors
site.

I've created a Excel doc that has
Ticketnumber (Link)
Date open
Status
Open by

I've added another column
for
Problem description
Resolution description.
What I need to do is
For each item in column A follow link
On the webpage that is given locate the word "Problem Description:"
Copy all text between "Problem Description:" and Problem Resolution:
and paste into my excel doc in the same row under "Problem description"

The vendor's site requires me to login - I don't mind storing my login
infomation within the excel doc.

Any thought?
Steve