Type in IE textbox

M

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 can you automate Excel?
Press Alt+F11 from Windows Excel to open the Visual Basic for Applications (VBA) editor.
Sort by date Sort by votes
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.'}}});
 
Upvote 0
You must log in or register to reply here.

Similar threads

G
  • Question
Using Excel formula to create HTML code text referencing specific cells
Replies
0
Views
825
gvsumich
G
V
  • Question
Input Text in RTE (iFrame) is becoming null after page refreshed/saved - VBA Macros
Replies
0
Views
1K
Vino22
V
M
  • Question
Help with FilterXML formula
Replies
0
Views
1K
montex01
M
E
  • Question
How to copy values from one workbook sheet to another, based on criterias ?
Replies
7
Views
2K
DanteAmor
DanteAmor
A
  • Question
Web Scraping using VBA
Replies
4
Views
9K
atr140
A

Forum statistics

Threads
1,214,877
Messages
6,122,051
Members
449,064
Latest member
scottdog129

Share this page

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