View Single Post
Old April 19th, 2005, 09:56 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
Default Excel VBA and Office Clipboard

I have an IE / Excel worksheet process that I am trying to automate via VBA.

Manually, the process looks like this:

 1) Run a web report to get results list.
 2) Since there is no way to convert to MS-Excel,
    with the webpage in focus press CTRL-A, CTRL-C.

 3) Select cell A1 in a blank worksheet.

 4) Paste the contents of the Office clipboard into the Excel sheet.

 5) Manually clean up the report since it does not come through properly formatted.

What I would like to do is some or all of the following:

a) Via message, tell the user to select his web site.
b) With the web page in focus, press CTRL-A (select all) and CTRL-C to copy the contents.
c) With cell A1 selected in the blank work sheet, press CTRL-V (paste)
d) Spend the next day or two cleaning up and formatting the report.

Does anyone know how to use EXCEL VBA to initiate a Office Clipboard copy in an external document (this case, a web page); then paste the data into the blank spread sheet without losing formatting?
Any help would be appreciated.:D

--- Tom
--- Tom