Paste from excel into Internet Explorer

[ftv]

Hello guys, i need a little help with some code, i have excel 2003, I work at a call center and in my spread sheet i have text that i use frequently to document my calls. I would like to create a button next to each cell, i only have text in column A going to A80 , i would like the button in B, and i would like the button to copy the cell next to it and paste it into my open IE window, Thanks in advance

 

[mtskv5]

Have you tried just hyperlinking the text?

 

[ftv]

No, I actually havnt I can try that but im not quite sure that will work to copy it will it? Also it needs to go in a specific box in ie

 

[mtskv5]

Sorry FTV,

Thought that you wanted to paste it into the address bar in IE.

 

[ftv]

Hey guys im still looking for help on this, i have some code that is like what i want my macro to do . I would like to essentially create a button along side my cells in column A in Column B and when i click on that button in B , it will copy the cell next to it and paste it into a certain box in ie, here is the code ive got for something similar just not for excel , Thanks in advance


*********>
******** type="text/javascript" src="common/JavaScript/UHGISETJavaScriptUtil.js">*********>
******** type="text/javascript" src="common/JavaScript/titleBar.js">*********>
******** type="text/javascript">
var origDomain = document.domain
var domainSuffix = origDomain.substring(origDomain.indexOf('.')+1)
var autoDocText = "";
function getActiveText(e) {
// Sets text MSIE or Netscape active
// text based on browser, puts text in form
// Only update autoDocText selection if the selection is
autoDocText = (document.all) ? docContent.document.selection.createRange().text : docContent.document.getSelection();
//alert('highlighted = ' + autoDocText)
return true;
}

// End -->

 

[ftv]

im not sure why it put an * but lets try that code again ,




</ script>
< script type="text/javascript" src="common/JavaScript/UHGISETJavaScriptUtil.js">*********>
******** type="text/javascript" src="common/JavaScript/titleBar.js">*********>
******** type="text/javascript">
var origDomain = document.domain
var domainSuffix = origDomain.substring(origDomain.indexOf('.')+1)
var autoDocText = "";
function getActiveText(e) {
// Sets text MSIE or Netscape active
// text based on browser, puts text in form
// Only update autoDocText selection if the selection is
autoDocText = (document.all) ? docContent.document.selection.createRange().text : docContent.document.getSelection();
//alert('highlighted = ' + autoDocText)
return true;
}

// End -->

 

[ftv]

i actually just found this, code, but not sure if this will do it



IE.Document.parentWindow.execScript "CheckAndSubmit(document.frmViewMyAcct);"</PRE><!-- / message -->

 

[ftv]

Any one got any help?

 

[ftv]

I still need help on this , if any one has anything please? Thanks

 

[ftv]

I think i may have been wording my request weirdly so that no one understands what im asking for, im looking to autofill text boxes on an already open website in internet explorer with data i have from my excel spreadsheet