View Single Post
  #3 (permalink)  
Old April 20th, 2005, 10:08 PM
tcarnahan tcarnahan is offline
Authorized User
Points: 306, Level: 6
Points: 306, Level: 6 Points: 306, Level: 6 Points: 306, Level: 6
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
Join Date: Jun 2003
Location: , , .
Posts: 54
Thanks: 2
Thanked 0 Times in 0 Posts

Thanks for your response!

The main reason why my customer asked for this is that the web application does not present the info in a fashion that he can use it directly AND the web developer "locked down" everything (can NOT right-click to see source code, bring up menus, etc.)

I was going to just copy the source code and parse out the stuff he wanted, but I was greated by a nasty little pop-up saying that I couldn't do it.

Today, I was able to CTRL-A (select All) and CTRL-C (copy) to get the report to the Office clipboard. Then I manually pasted it to an Excel spreadsheet. I ran my VBA routine to do the following: removed all the "shapes" that the web page put in; searched to find out what row my data started on; deleted all rows not associated with my data; deleted some columns that were not needed; converted some "text numbers" to real numbers.

The part I would like to automate is:

 - Switch to the IE window
 - Automatical copy to Office clipboard
 - Switch back to Excel
 - Paste from the Office clipboard to the Excel sheet.

Any thoughts?

--- Tom
Reply With Quote