Paste from excel into Internet Explorer

ftv

Board Regular
Joined
Sep 27, 2010
Messages
74
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
 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college
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
 
Upvote 0
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 -->
 
Upvote 0
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 -->
 
Upvote 0
i actually just found this, code, but not sure if this will do it



IE.Document.parentWindow.execScript "CheckAndSubmit(document.frmViewMyAcct);"</PRE><!-- / message -->
 
Upvote 0
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
 
Upvote 0

Forum statistics

Threads
1,224,502
Messages
6,179,126
Members
452,890
Latest member
Nikhil Ramesh

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top