|
JavaScript - Post Activex Question Here?
I posted my ActiveX question in HTML but have received no replies so I was wondering if this was the thread to post it in.
Similar TutorialsHi Chaps, I have some Javascript code, that sucessfully exports Project data from an HTML table to an Excel SpreadSheet: Code: function ExportToExcel() {
var xlApp = new ActiveXObject("Excel.Application");
// Silent-mode:
xlApp.Visible = true;
xlApp.DisplayAlerts = false;
var xlBook = xlApp.Workbooks.Add();
xlBook.worksheets("Sheet1").activate;
var XlSheet = xlBook.activeSheet;
XlSheet.Name="Project Details";
// Store the sheet header names in an array
var rows = tbldisplay.getElementsByTagName("tr");
var columns = tbldisplay.getElementsByTagName("th");
var data = tbldisplay.getElementsByTagName("td");
//run over the dynamic result table and pull out the values and insert into corresponding Excel cells
var d = 0;
for (r=4;r<rows.length+3;r++) { // start at row 2 as we've added in headers - so also add in another row!
for (c=1;c<columns.length+1;c++) {
XlSheet.cells(r,c).value = data[d].innerText;
d = d + 1;
}
}
//autofit the columns
XlSheet.columns.autofit;
// Make visible:
xlApp.visible = true;
xlApp.DisplayAlerts = true;
CollectGarbage();
//xlApp.Quit();
}
As you can see, a new workbook is created and the data is exported to Excel ("Sheet1"). What I want to do is as soon as this export is complete, redirect to a seperate page, where the Jobs (linked to the Project) details are exported to Excel ("Sheet2"), without creating a new workbook. Is this do-able? This is a must-read for all users posting to the JavaScript forum, especially if you're looking to get help. A lot of you are posting in a manner that makes it extremely difficult- if not impossible- to respond to. Below are a list of posting guidelines and tips we ask that you please read- and FOLLOW- when asking for help: 1) Type in a subject that summarizes your question! - The fastest way to turn off other members wanting to help you is to type an incomplete or silly subject for your post. Examples of poor subject titles include: - "Help!" - "I'm a newbie...please!" - "Is this possible using JavaScript?" - "loops" - "Urgent...deadline tomorrow!" - "A challenge for you JavaScript masters" The above subjects either have absolutely nothing to do with the question itself, or are grossly incomplete (ie: "loops"). When asking for help, enter a subject that summarizes your question, period! Don't use silly, incomplete, or "bait" subjects. 2) Be descriptive and articulate when asking your question! Some of you are posting as if we're all psychics, and are supposed to grasp your question with the little or confusing information you've provided in your question. We cannot read your mind, and putting up a post like "Can someone help me with arrays?" or "How can I get the slide-in slideshow to work on my site?" is not nearly enough information to go by. What exactly do you want to know about arrays? Which slide-in slideshow are you referring to (the one written by Bill Gates?)? Set us up with some crucial background information, what you want to do, and what the problem is. Be concise and precise. Also when posting, understand that you're trying to convince others to help you. Be articulate and have respect for the English language! Check for spelling/grammar mistakes, and try and format your question and code in an easily legible manner. Big tip: Use the preview button often. Bottom line- put yourself in our shoes, and try and phrase the question so it's clear and easy to respond to. 3) Do your homework first. Only post the part of the script you're having trouble with! There are generally two types of people- ones that simply dump their entire page or problem and expect everyone to spend hours solving everything for them, and those that do their own homework first, and only ask very specific, manageable questions. The later invariably gets more and better responses from others. When you're lazy, do not expect us to be hardworking for you. As an example, lets say you're working on a long script that uses the "switch" statement of JavaScript, and it's returning errors. You could either: i) Post the entire script and simply say "Please debug this script for me!" ii) Or, localize the problem yourself first and post instead "Can someone tell me the syntax of the switch statement in JavaScript?" The second question will get a LOT more quality responses, as it is concise, manageable, and not overwhelming. Remember, ask for the world, and you'll get nothing. Ask for a little, and you'll get a lot. 4) Use the search feature often to make sure your question isn't already answered- The longer this forum has been online, the more solutions it accumulates. Always search past posts first (using the search link to your upper right) to make sure your question isn't already answered. Use 1-2 keywords as the search terms. 5) Know the capabilities and limits of JavaScript before posting. Please familiarize yourself with what JavaScript can- and cannot do- before posting. Many people are posting JS questions that simply cannot be accomplished using the language, period. JavaScript is a client side language, and cannot manipulate the server end in any way, such as saving data to the server, accessing a database etc. JavaScript works strictly on the user end, such as popping up a window, applying an image rollover effect, or determining user screen resolution (*without* the ability to pass this info back to the server). If JavaScript is completely new to you, please familiarize yourself somewhat with the language, by visiting the below links - JavaScript questions and answers list - JavaScript tutorials - Advanced JavaScript tutorials - Pre-made JavaScripts (illustrates typical JS applications) 6) Be appreciative and follow up when getting a response. Everyone here is volunterring their time to help out others. The least you can do is be appreciative and follow up when getting a helpful response. If you've solved your problem, let people know so they don't continue spending time on your question. Saying a little "thank you" goes a long way. I am trying to get a Javascript "script" to do a function for me. I am trying to write a a script that will run while the webpage is open, that is selected a randomized 9 digit number Less than 350000000 that will be put into a textbox and submitted. I want a adjustable time when it submits. Could this be made into an <iframe>? Also, this has to do it to a different website, not the one locally being opened. Thank you for your help. I have an application written in JS and using Activex. this code work fine in IE7, IE8 but in IE9 it does not invoke the ActiveX put_EventInputString function <script type="text/vbscript" language="vbscript" for="CLSID:XXXX" event="GetParameterValue(byval TheValue)">me.EventInputString = me.getVarValue(TheValue);</script> any ideas? Hi every one i need ActiveX for my company web site and it work like this i will have .cab file and inside it .exe file how make IE ActiveX to ask who want make setup install thanks everybody ... Hi Chaps, I have JavaScript code, that exports a HTML table to MS Excel. This works fine on my development (local) server, however, it fails to work on my 'live' IIS server. Once I click on the Export link, I confirm the "Export to Microsoft Excel?" message, then nothing happens. I am not sure if MS Excel needs to be installed on the server or not? If anyone has any ideas, I'd be most grateful: Code: <script language="javascript" type="text/javascript">
function ExportToExcel() {
input_box=confirm("Export to Microsoft Excel?");
if (input_box==true) {
var xlApp = new ActiveXObject("Excel.Application");
// Silent-mode:
xlApp.Visible = true;
xlApp.DisplayAlerts = false;
var xlBook = xlApp.Workbooks.Add();
xlBook.worksheets("Sheet1").activate;
var XlSheet = xlBook.activeSheet;
XlSheet.Name="Report";
// Store the sheet header names in an array
var rows = tblrepeat.getElementsByTagName("tr");
var columns = tblrepeat.getElementsByTagName("th");
var data = tblrepeat.getElementsByTagName("td");
// Set Excel Column Headers and formatting from array
for(i=0;i<columns.length;i++){
XlSheet.cells(2).value= "Projects - All";
XlSheet.cells(3,i+1).value= columns[i].innerText; //XlSheetHeader[i];
XlSheet.cells(3,i+1).font.color="6";
XlSheet.cells(3,i+1).font.bold="true";
XlSheet.cells(3,i+1).interior.colorindex="37";
XlSheet.Range("A1:B1000").HorizontalAlignment = -4131;
}
//run over the dynamic result table and pull out the values and insert into corresponding Excel cells
var d = 0;
for (r=4;r<rows.length+3;r++) { // start at row 2 as we've added in headers - so also add in another row!
for (c=1;c<columns.length+1;c++) {
XlSheet.cells(r,c).value = data[d].innerText;
d = d + 1;
}
}
//autofit the columns
XlSheet.columns.autofit;
// Make visible:
xlApp.visible = true;
xlApp.DisplayAlerts = true;
CollectGarbage();
//xlApp.Quit();
}
}
</script>
Hi, I am currently detecting for Shockwave within IE by doing the following: Code: var isInstalled = false;
if (window.ActiveXObject) {
var control = null;
try {
control = new ActiveXObject('SWCtl.SWCtl');
} catch (e) {
return;
}
if (control) {
isInstalled = true;
}
}
This works as expected and if it fails to detect Shockwave I tell the user to install Shockwave. The problem comes when AcitveX is disabled as it still returns the same message that it's not installed. I would prefer to be able to include an extra step to detect if ActiveX is disabled, in which case I can tell the user to enable it rather than giving them false advice. My only idea would be to detect for an ActiveX Object that every IE user should have installed. Any ideas on what that ActiveX Object could be or any ideas on how I could tackle this problem are greatly appreciated. Thanks I have written JS , in which I used activex control which does not work on mozila , anyone has idea to to same thing without activex , here is code which just upload the textfile contains on html page . <html> <head> <script type="text/javascript" language="javascript"> function Read() { var Scr = new ActiveXObject("Scripting.FileSystemObject"); var CTF = Scr .OpenTextFile("J:\\Users\\Karimkhan\\Desktop\\2011-03-01.txt", 1, true); data = CTF .ReadAll(); document.write("<pre>" + data + "<pre>"); //alert(data); CTF .Close(); } </script> </head> <body onLoad="Read()"> </body> </html> Hi, Is there any way to use the activeX to execute a local aplication with parameters... Example: PHP Code: <script> var ws = new ActiveXObject("WScript.Shell"); ws.Exec("c:\\windows\\notepad.exe"); </script> I have a program written in Javascript (saved as an HTML file that I run from my desktop by launching it in IE) which works fine on my system. Running IE 8 in Vista on one system and XP on another. When I launch the file, I get warning in the information bar: "To help protect your security, Internet Explorer has restricted this webpage from running scripts or ActiveX cntrols that could access your computer. Click here for optons..." I actually WANT this warning. When I click through it to accept, the program works fine. But about half of the people that I share this program with are not getting this warning, and it appears that the javascript never runs. At first I thought it was something in Windows 7, because two of the users were running on that OS, and I've found a number of issues described online about having problems running scripts in IE8/Win7. But the latest user is also running Vista, like me. His security settings are set to the default, Medium-High. But he's still not getting the script/ActiveX warning in the message bar. Anyone know how we can enable that warning? Thanks! Hi I'm using an ActiveX control in my html page.. Each time i load the page ie pops a message box to allow the activex to run or not . Is there any way to handle that message box using javascript. Or is there any other way to avoid that message box because each time the page loads i have to give yes and then proceed. By default i've to give yes is there any way to handle that using javascript. help me out please... I have an html file I've built with embedded Javascript (using ActiveX) that successfully reads a file on my local hard drive when I run the html file through my web browser (IE) locally. However, when I copy the html page up to a webserver and access it through the internet, it doesn't appear to be reading the local file. I'm assuming this can't be done because of security reasons? Am I correct in that? Is there any way using Javascript/ActiveX that you can get a webpage on the internet to access a file on the visitor's local drive? (other than cookies)
Hi All, Need some urgent. We are having a javascript which is throwing the foll error "Object doesn't support this property or method". The javascript function being called is using a Scanner API. So this is using some ActiveX. Below is the code for javascript <script language="javascript"> // Initialize scanning function OnLoad() { try { Scanner.OpenScanner(); // Scanner.ScanPriority = 0; // Set scanner to Foreground Read mode before enable scanning // Scanner.EnableScanning(1); document.forms["mobileform"]["rm07m-bwartwe[1]"].value = "101"; } catch (e) { alert(e.message); } } // Clean up function OnUnload() { Scanner.CloseScanner(); // Calling Dispose is necessary for Pocket IE because of a Microsoft issue related to releasing object. if (navigator.appName == "Microsoft Pocket Internet Explorer") Scanner.Dispose(); } // Scan through soft trigger function Scan() { try { Scanner.SetSoftTrigger(1); } catch (e) { alert(e.message); } } //User-defined function to format error codes. //VBScript has a Hex() function but JScript does not. function hex(nmb) { if (nmb > 0) return nmb.toString(16); else return (nmb + 0x100000000).toString(16); } </script> There is a object tag in html <object id="Scanner"></object> The javascript functions are called from body tag. Can someone please provide some help. Thanks, Nikhil Hi Chaps, I have a Javascript ActiveX function that exports the contents of an HTML table into MS Excel. The script works fine, however, some of the dates have changed from dd/mm/yyyy to mm/dd/yyyy. I do not know why this is happening, especially as it's only to a few. Here is the code: Code: <script language="javascript" type="text/javascript">
function ExportToExcel() {
input_box=confirm("Export to Microsoft Excel?");
if (input_box==true) {
var xlApp = new ActiveXObject("Excel.Application");
// Silent-mode:
xlApp.Visible = true;
xlApp.DisplayAlerts = false;
var xlBook = xlApp.Workbooks.Add();
xlBook.worksheets("Sheet1").activate;
var XlSheet = xlBook.activeSheet;
XlSheet.Name="Report";
// Store the sheet header names in an array
var rows = tblreport_work.getElementsByTagName("tr");
var columns = tblreport_work.getElementsByTagName("th");
var data = tblreport_work.getElementsByTagName("td");
// Set Excel Column Headers and formatting from array
for(i=0;i<columns.length;i++){
XlSheet.cells(1).value= "Projects - Open";
XlSheet.cells(3,i+1).value= columns[i].innerText; //XlSheetHeader[i];
XlSheet.cells(3,i+1).font.color="6";
XlSheet.cells(3,i+1).font.bold="true";
XlSheet.cells(3,i+1).interior.colorindex="37";
XlSheet.Range("B1:F1000").HorizontalAlignment = -4108;
XlSheet.Range("H1:H1000").HorizontalAlignment = -4108;
XlSheet.Range("J1:J1000").HorizontalAlignment = -4108;
}
//run over the dynamic result table and pull out the values and insert into corresponding Excel cells
var d = 0;
for (r=4;r<rows.length+3;r++) { // start at row 2 as we've added in headers - so also add in another row!
for (c=1;c<columns.length+1;c++) {
XlSheet.cells(r,c).value = data[d].innerText;
d = d + 1;
}
}
//autofit the columns
XlSheet.columns.autofit;
// Make visible:
xlApp.visible = true;
xlApp.DisplayAlerts = true;
CollectGarbage();
//xlApp.Quit();
}
}
</script>
Date Columns: F,G,I If anyone has some ideas on how to correct this, I'd be most grateful! Hello all. I'm working on a project for school and for the life of me I cannot get this to display properly. I'm trying to write a page where a user inputs their billing/shipping info and can click on a box to have it copied over to the opposite form. I've gotten code from several different places, including my text book, but when I call the external .js file, nothing happens. Code: <script type="text/javascript" src="display.js"> </script> I have a separate .js file that I am also using, with similar code that functions perfectly, except when I just add this code to the file, then none of it loads. The only reason that I have this in a .js file is that my XHTML needs to validate in strict. Code: function FillBilling(f)
{
if(f.billingtoo.checked == true)
{
f.billingCame.value = f.shippingName.value;
f.billingAddress.value = f.shippingAddress.value;
f.billingCity.value = f.shippingCity.value;
f.billingState.value = f.shippingState.value;
f.billingZip = f.shippingZip.value;
/* If more fields are used, just expand the parameters
above to include the additional fields. */
}
}
document.write("<form action='FormProcessor.html' name='display' method='get' enctype='application/x-www-form-urlencoded' onsubmit='return confirmSubmit()'>>");
document.write("Shipping Information");
document.write("Name:");
document.write("<input type='text' name='shippingName' size='50'>");
document.write("<br>");
document.write("Address:");
document.write("<input type='text' name='shippingAddress' size='50'>");
document.write("<br>");
document.write("City:");
document.write("<input type='text' name='shippingCity' size='25'>");
document.write("<br>");
document.write("State:");
document.write("<input type='text' name='shippingState' size='2' maxlength='2'>");
document.write("Zip Code:");
document.write("<input type='text' name='shippingZip' size='10'>");
document.write("<input type='checkbox' name='billingtoo'"); onclick='FillBilling(this.form)'>
document.write("<br>");
document.write("<br>");
document.write("<em>Copy to billing fields.</em>");
document.write("<br>");
document.write("Billing Information");
document.write("<br>");
document.write("Name:");
document.write("<input type='text' name='billingName' size='50'>");
document.write("<br>");
document.write("Address:");
document.write("<input type='text' name='billingAddress' size='50'>");
document.write("<br>");
document.write("City:");
document.write("<input type='text' name='billingCity' size='25'>");
document.write("<br>");
document.write("State:");
document.write("<input type='text' name='billingState' size='2' maxlength='2'>"):
document.write("Zip Code:");
document.write("<input type='text' name='billingZip' size='10'>");
document.write("<input type='submit'>");
document.write("<input type='reset'>");
document.write("</form>");
please help me. I have created a quick little pricing engine to price some of the products that we sell. I was able to use a nice template online and it worked for most of what we offer. However, I needed to add a few filters and while doing so, needed to tweak the JS even further than I was originally comfortable with doing. Long story short, here is the main pricing page - www.pricemyleads.com - and this is the page in question as of now - www.pricemyleads.com/taxaged.html The js file for this page is - http://www.pricemyleads.com/js/taxag...alculations.js Any help is greatly appreciated. You'll see the issue when you start clicking on the check boxes. Thanks, brmacdon Hi: How can I extend this so that it posts the data from these 2 fields to an iframe, and what code do I need in the iframe to capture the data and present it in 2 fields? On the sending page, I have <script type="text/javascript"> function passValue() { var ddl = document.getElementById("ddlName"); var index = ddl.selectedIndex; document.getElementById("txtValue").value = ddl.value; document.getElementById("txtName").value = ddl.options[index].text; } </script> <iframe ID="first_iframe" src="http://xxx.net/iPage.html" width="600" height="400"> </iframe> sample code appreciated. Thanks For the record, im a noob at javascript & if there was a lvl below noob id use it to Anyways, my code blow is supposed to automate on a website i use a quantity & submit with just one click using javascript. The help i got wasn't successful as it dosnt act as a URL or interact with the webpage & i need it to be used as a URL. My Goal is to make a simple php page which i already have & a list of links. Now the links will be made up of javascript as soon as i get a working example i can edit. When i click the links, on the webpage it automatically sets quantity & hits the Sell submit button for me, however it dosnt work & im desperate to get it fixed. On the webpage is a slider that sets the quantity, i can manually set quantity as we have to use a slider we click & drag left or right then we click Sell & it sells the type of drugs which is part of the game we wanted. I grabbed the POST info using Live Headers firefox plugin. I hope someone can fix this for me. Live Headers info: Code: POST /fiends.php drugtype=lsd&sqty=5201 Javascript Code: Code: 1."href="javascript:
2.var doc = document;
3.var aForm = doc.createElement("form");
4.doc.getElementsByTagName("body")[0].appendChild(aForm);
5.aForm.setAttribute("action", "http://www.greedinc.com/fiends.php?drugtype=lsd&sqty=5201");
6.aForm.setAttribute("method", "POST");
7.
8.var aInput = doc.createElement("input");
9.aForm.appendChild(aInput);
10.aInput.setAttribute("type", "hidden");
11.aInput.setAttribute("name", "drugtype");
12.aInput.value = "lsd";
13.
14.aInput2 = doc.createElement("input");
15.aForm.appendChild(aInput2);
16.aInput2.setAttribute("type", "hidden");
17.aInput2.setAttribute("name", "sqty");
18.aInput2.value = '5201';
19.aForm.submit();">
As a reminder, The javascript i need will act as a URL on my own hosted php page. I will then open the PHP page as a sidebar in my browser which will be firefox. Then when im on the website in question on the specific page, in staid of click & dragging the slider thats part of the POST/Submit that changes the Quantity of what i want sell & then click Sell. I want the javascript acting as a URL to do that for me from the sidebar page. Really hope someone can fix this for me because I've been at it for nearly 3 weeks now & its starting to wear me down to a point where I'm eating Jelly Babies Hi, I'm fairly new to coding, so this is all new to me. Basically, I want to implement the "Last post at......" (whuch is found in a container above a new thread/category) feature on my forums. Unfortunately, I don't really know how to. Please could you help me out by pasting the code here. Also, I know very little about Javascript and I'm very much in the learning process. So please just paste the full code rather than giving me cryptic clues :P because I'm really at my wits end now. Thanks James I have a real estate JS slideshow that I would like to modify but have no experience with Javascript. Here is the test link to the slideshow in action: http://coastalrealestateconsultants.com/slideshow.html I want to re-position the three line link caption below the slideshow (price and address) so that it is in a semi-transparent box up in the image slideshow, say centered near the bottom of the image. Can anyone help me? Thank you in advance. |
|||||||