Copy HTML with VBScript? 1

link9 · Dec 16, 2000

I need to be able to put a vbscript function on a page that will copy the page onto the clipboard so that it can be pasted into excel later. The users for this site are not what we would call 'savvy', so they want a quick and easy button to push, and it's up to me to give it to them.

Does anyone out there know of a way to do this?

Javascript would also be fine if you know of a function that way.

Thank you,
Paul Prewett

RobSchultz · Dec 21, 2000

In IE you can do the following...

Code:

<html>
<script language=&quot;javascript&quot;>
function fnDoCopy(){
 textRange = document.body.createTextRange();
 textRange.moveToElementText(tblCopy);
 textRange.execCommand(&quot;Copy&quot;);
 alert(&quot;The table has been copied to your Windows clipboard.\n\nYou can paste this information into Excel, Word, etc.&quot;)
}
</script>
<body>
<a href=&quot;javascript:fnDoCopy()&quot;>Copy</a><br>
<table id=&quot;tblCopy&quot; name=&quot;tblCopy&quot;><tr><td>Here is some stuff</td></tr></table>
</body>
</html>

Hope it helps, Rob
robschultz@yahoo.com
-Focus on the solution to the problem, not the obstacles in the way.-

link9 · Dec 21, 2000

Thank you Rob. (=

It works.

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Copy HTML with VBScript? 1

link9

Programmer

RobSchultz

Programmer

link9

Programmer

Similar threads

Part and Inventory Search

Sponsor