Type in IE textbox

Mepwnz2010

New Member
Joined
Aug 20, 2014
Messages
9
I'm creating a macro to automate a webpage for work. Since its for work I cant link the URL but I can give the code for the text box.

HTML:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"><html dir="ltr" lang="en"><head><title>Rich text editor, 00NC0000004y1ygMAA, press ALT 0 for help.</title><base href="https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/" data-cke-temp="1" /><link type="text/css" rel=stylesheet href="/sCSS/31.0/sprites/1408634266000/Theme3/default/ie7/HtmlDetailElem.css"><link type="text/css" rel=stylesheet href="/sCSS/31.0/sprites/1408634266000/Theme3/default/ie7/CKEditor.css"><style type="text/css" data-cke-temp="1">img.cke_flash{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/flash/images/placeholder.png?t=3.6.2.15);background-position: center center;background-repeat: no-repeat;border: 1px solid #a9a9a9;width: 80px;height: 80px;}form{border: 1px dotted #FF0000;padding: 2px;}
img.cke_hidden{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/forms/images/hiddenfield.gif?t=3.6.2.15);background-position: center center;background-repeat: no-repeat;border: 1px solid #a9a9a9;width: 16px !important;height: 16px !important;}img.cke_iframe{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/iframe/images/placeholder.png?t=3.6.2.15);background-position: center center;background-repeat: no-repeat;border: 1px solid #a9a9a9;width: 80px;height: 80px;}ul,ol{	margin-left: 0px;	padding-left: 40px;}a.cke_anchor,a.cke_anchor_empty,a[name],a[data-cke-saved-name]{background:url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/link/images/anchor.gif?t=3.6.2.15) no-repeat left center;border:1px dotted #00f;padding-left:18px;cursor:auto;}a.cke_anchor_empty{display:inline-block;}img.cke_anchor{background:url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/link/images/anchor.gif?t=3.6.2.15) no-repeat left center;border:1px dotted #00f;width:16px;min-height:15px;height:1.15em;vertical-align:text-bottom;}div.cke_pagebreak{background: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/pagebreak/images/pagebreak.gif?t=3.6.2.15) no-repeat center center !important;clear: both !important;width:100% !important; _width:99.9% !important;border-top: #999999 1px dotted !important;border-bottom: #999999 1px dotted !important;padding:0 !important;height: 5px !important;cursor: default !important;}.cke_show_blocks  p,.cke_show_blocks  div,.cke_show_blocks  pre,.cke_show_blocks  address,.cke_show_blocks  blockquote,.cke_show_blocks  h1,.cke_show_blocks  h2,.cke_show_blocks  h3,.cke_show_blocks  h4,.cke_show_blocks  h5,.cke_show_blocks  h6{background-repeat: no-repeat;background-position: top left;border: 1px dotted gray;padding-top: 8px;padding-left: 8px;}.cke_show_blocks  p{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_p.png);}.cke_show_blocks  div{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_div.png);}.cke_show_blocks  pre{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_pre.png);}.cke_show_blocks  address{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_address.png);}.cke_show_blocks  blockquote{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_blockquote.png);}.cke_show_blocks  h1{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_h1.png);}.cke_show_blocks  h2{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_h2.png);}.cke_show_blocks  h3{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_h3.png);}.cke_show_blocks  h4{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_h4.png);}.cke_show_blocks  h5{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_h5.png);}.cke_show_blocks  h6{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_h6.png);}.cke_show_borders  table.cke_show_border,.cke_show_borders  table.cke_show_border > tr > td, .cke_show_borders  table.cke_show_border > tr > th,.cke_show_borders  table.cke_show_border > tbody > tr > td, .cke_show_borders  table.cke_show_border > tbody > tr > th,.cke_show_borders  table.cke_show_border > thead > tr > td, .cke_show_borders  table.cke_show_border > thead > tr > th,.cke_show_borders  table.cke_show_border > tfoot > tr > td, .cke_show_borders  table.cke_show_border > tfoot > tr > th{border : #d3d3d3 1px dotted}html {	_overflow-y: scroll; cursor: text;	*cursor:auto;}img, input, textarea { cursor: default;}</style></head><body id="00NC0000004y1ygMAA_rta_body"></html>******** id="cke_actscrpt" type="text/javascript" data-cke-temp="1">window.parent.CKEDITOR.tools.callFunction( 46, window );*********>
I've filled out other text boxes on this same webpage using

Code:
ie.document.all("00NC0000004ytz0").Value = ThisWorkbook.Sheets("sheet1").Range("a1")

And I'm trying to do the same thing, but this box seems to be some other type of program overlapped onto the webpage. Using the name I've got it to not give me an error, but the text isn't in the box after the macros done. I think its because this program is hidden but I'm not really sure.


<link type="text/css" rel="stylesheet" href="/sCSS/31.0/sprites/1408634266000/Theme3/default/ie7/HtmlDetailElem.css"><link type="text/css" rel="stylesheet" href="/sCSS/31.0/sprites/1408634266000/Theme3/default/ie7/CKEditor.css"><style type="text/css" data-cke-temp="1">img.cke_flash{background-image: url(https://na8.salesforce.com/ckeditor...ceholder.png?t=3.6.2.15);background-position: center center;background-repeat: no-repeat;border: 1px solid #a9a9a9;width: 80px;height: 80px;}
form{border: 1px dotted #FF0000;padding: 2px;}


img.cke_hidden{background-image: url(https://na8.salesforce.com/ckeditor...denfield.gif?t=3.6.2.15);background-position: center center;background-repeat: no-repeat;border: 1px solid #a9a9a9;width: 16px !important;height: 16px !important;}
img.cke_iframe{background-image: url(https://na8.salesforce.com/ckeditor...ceholder.png?t=3.6.2.15);background-position: center center;background-repeat: no-repeat;border: 1px solid #a9a9a9;width: 80px;height: 80px;}
ul,ol{ margin-left: 0px; padding-left: 40px;}
a.cke_anchor,a.cke_anchor_empty,a[name],a[data-cke-saved-name]{background:url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/link/images/anchor.gif?t=3.6.2.15) no-repeat left center;border:1px dotted #00f;padding-left:18px;cursor:auto;}a.cke_anchor_empty{display:inline-block;}img.cke_anchor{background:url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/link/images/anchor.gif?t=3.6.2.15) no-repeat left center;border:1px dotted #00f;width:16px;min-height:15px;height:1.15em;vertical-align:text-bottom;}
div.cke_pagebreak{background: url(https://na8.salesforce.com/ckeditor...ins/pagebreak/images/pagebreak.gif?t=3.6.2.15) no-repeat center center !important;clear: both !important;width:100% !important; _width:99.9% !important;border-top: #999999 1px dotted !important;border-bottom: #999999 1px dotted !important;padding:0 !important;height: 5px !important;cursor: default !important;}
.cke_show_blocks p,.cke_show_blocks div,.cke_show_blocks pre,.cke_show_blocks address,.cke_show_blocks blockquote,.cke_show_blocks h1,.cke_show_blocks h2,.cke_show_blocks h3,.cke_show_blocks h4,.cke_show_blocks h5,.cke_show_blocks h6{background-repeat: no-repeat;background-position: top left;border: 1px dotted gray;padding-top: 8px;padding-left: 8px;}.cke_show_blocks p{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_p.png);}.cke_show_blocks div{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_div.png);}.cke_show_blocks pre{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_pre.png);}.cke_show_blocks address{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_address.png);}.cke_show_blocks blockquote{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_blockquote.png);}.cke_show_blocks h1{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_h1.png);}.cke_show_blocks h2{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_h2.png);}.cke_show_blocks h3{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_h3.png);}.cke_show_blocks h4{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_h4.png);}.cke_show_blocks h5{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_h5.png);}.cke_show_blocks h6{background-image: url(https://na8.salesforce.com/ckeditor/ckeditor-3.6.2/_source/plugins/showblocks/images/block_h6.png);}
.cke_show_borders table.cke_show_border,.cke_show_borders table.cke_show_border > tr > td, .cke_show_borders table.cke_show_border > tr > th,.cke_show_borders table.cke_show_border > tbody > tr > td, .cke_show_borders table.cke_show_border > tbody > tr > th,.cke_show_borders table.cke_show_border > thead > tr > td, .cke_show_borders table.cke_show_border > thead > tr > th,.cke_show_borders table.cke_show_border > tfoot > tr > td, .cke_show_borders table.cke_show_border > tfoot > tr > th{border : #d3d3d3 1px dotted}
html { _overflow-y: scroll; cursor: text; *cursor:auto;}
img, input, textarea { cursor: default;}</style>
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)

Mepwnz2010

New Member
Joined
Aug 20, 2014
Messages
9
Forgot to add this part of the text box. I'm not sure but I dont think the first part even matters.

HTML:
Contact/Account Lookup Results********>CKEDITOR.timestamp = '3.6.2.15';var protocolAndHost = ****************.protocol + '//' + ****************.host;var editor = CKEDITOR.replace('00NC0000004y1ygMAA', {removePlugins : 'elementspath,maximize,image,contextmenu,resize', baseHref : protocolAndHost + '/ckeditor/ckeditor-3.6.2/', customConfig : '/ckeditor/ckeditor-3.6.2/ckeditor.config.js', height : '170', bodyId : '00NC0000004y1ygMAA_rta_body', toolbar : 'SalesforceBasic', sharedSpaces : { top : 'cke_topSpace', bottom : ' cke_bottomSpace' }, filebrowserImageUploadUrl : '/_ui/common/request/servlet/RtaImageUploadServlet', contentsCss : ['/sCSS/31.0/sprites/1408634266000/Theme3/default/ie7/HtmlDetailElem.css', '/sCSS/31.0/sprites/1408634266000/Theme3/default/ie7/CKEditor.css'], disableNativeSpellChecker : true, language : 'en-us',sfdcLabels : { CkeMediaEmbed : { title : 'Embed Multimedia Content', description : 'Use ********> code from DailyMotion, Vimeo, and Youtube.', subtitle : 'Paste <iframe> code here:', exampleTitle : 'Example:', example : '\n            \n                ******** width=\"560\" height=\"315\" src=\"https://www.youtube.com/embed/KcOm0TNvKBA\" frameborder=\"0\" allowfullscreen>*********>\n            \n        ', iframeMissing : 'Invalid ********> element. Please use valid code from the approved sites.'}, sfdcSwitchToText : { sfdcSwitchToTextAlt : 'Use plain text'}, CkeImageDialog : { uploadTab : 'Upload Image', infoTab_url : 'URL', error : 'Error:', uploadTab_desc_info : 'Enter a description of the image for visually impaired users', uploadTab_desc : 'Description', infoTab_url_info : 'Example: http://www.mysite.com/myimage.jpg', btn_insert : 'Insert', missingUrlError : 'You must enter a URL', uploadTab_file : 'Select Image', infoTab_desc : 'Description', btn_upadte : 'Update', wrongFileTypeError : 'You can insert only .gif .jpeg and .png files.', infoTab : 'Web Address', title : 'Insert Image', infoTab_desc_info : 'Enter a description of the image for visually impaired users', imageUploadLimit_info : 'Max number of upload images exceeded', uploadTab_file_info : 'Maximum size 1 MB. Only png, gif or jpeg'}, CkeImagePaste : { CkeImagePasteWarning : 'Pasting an image is not working properly with Firefox, please use [Copy Image location] instead.'}}});
 

Watch MrExcel Video

Forum statistics

Threads
1,133,243
Messages
5,657,574
Members
418,401
Latest member
B_A_M155

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
Top