ActiveX - How To Save Excel Workbook To Network
Jul 1, 2010
I have an ActiveX Javascript function, that pulls data from an HTML table and then populates an Excel Workbook. This works OK, but I need to save the workbook to a network path. I have successfully saved it locally:
Code:
// Save the Excel Workbook
xlBook.SaveAs("C:\TEST.XLSX");
But this does not:
Code:
// Save the Excel Workbook
xlBook.SaveAs("\Server\Projects\TEST.XLSX");
When attempting this, I get this error:
SaveAs method of Workbook class failed
Which refers to the above. I have tried different variations, but with little success (sometimes the path will default to the Server's 'My Documents'/'User Shared' folder, with the filename:
ServerProjectsTEST.XLSX
View 5 Replies
ADVERTISEMENT
May 26, 2009
Im opening an excel worksheet and adding data to it using Javascript ActiveX Excel Object as below
var Excel,Book;
Excel = new ActiveXObject("Excel.Application");
Book = Excel.Workbooks.Open("c:/example.xls");
var excel_sheet = Book.Worksheets("Sheet1");
[code]....
In the above code the column A in excel worksheet will have a unique value.I need to delete the entire row matching the value in column A and shift the rest of the rows up using this Javascript ActiveX Excel Object.
View 1 Replies
View Related
Jan 22, 2010
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]....
View 4 Replies
View Related
Sep 5, 2009
I need a javascript function to save a html table in my web page to excel work sheet on click of a button.
View 2 Replies
View Related
Nov 6, 2007
Both an EtherNet (wire) network and a wireless network are referred to
as a Local Area Network (LAN). A wireless network does not require
hubs, switchers, or routers to include additional users on the
network. Additional wireless users are supported just by being in the
immediate physical span of the network.
A wireless LAN (or Wi-Fi network) may be configured in two different
ways:
Ad Hoc mode: Allows only for communication between different personal
computers and wireless devices, often referred to as peer-to-peer
communication.
Infrastructure mode: Required for communication with the World Wide
Web, a printer, or a wired device of any sort. In either case, this
wireless connection requires a wireless network adaptor, often called
a WLAN card. Code:
View 3 Replies
View Related
Jul 20, 2005
Is it possible to read the computers IP address and gateway address
using Javascript?
View 2 Replies
View Related
Oct 13, 2011
Looking over other threads on this site I was able to use another members script to build my own for adding a network printer via JavaScript on our Intranet. With that, the script works perfectly fine when testing it on the local machine I built it on, but not on other machines in the office. Currently I'm remoted into the branch office I reside in from the corporate office where I'm currently at so the machines being tested are on different subnets, but the script is simple calling the UNC path for the printer. When tested on any other computer, and the link is clicked on the page, the user is taken back to the folder in windows explorer the HTML file is saved in, rather than executing the add printer portion of the script.
This is my full code as of now, I was trying to get the function correct before formatting the actual website (obviously)
Code:
<html><head>
<meta http-equiv="Content-Language" content="en-gb">
<meta http-equiv="Content-Type" content="text/html; charset=windows-1252">
<title>Printer Mapping</title>
</head>
<script>
function addPrinter25(){
var x=confirm("You are about to add printer GPSACC01. Would you like to make this your default printer?")
if (x==true){
WshNetwork = new ActiveXObject("WScript.Network");
var PrinterPath = "\\gpsprnt02\gpsacc01";
WshNetwork.AddWindowsPrinterConnection(PrinterPath);
WshNetwork.SetDefaultPrinter(PrinterPath);
alert("Printer GPSACC01 has been added successfully and set as default")
}else{
WshNetwork = new ActiveXObject("WScript.Network");
var PrinterPath = "\\gpsprnt02\gpsacc01";
WshNetwork.AddWindowsPrinterConnection(PrinterPath);
alert("Printer GPSACC01 has been added successfully")
}}
</script>
<font color="#0000FF" face="Arial">
<a href="" onclick="addPrinter25(); return false;">GPSACC01</a></font>
</body></html>
View 1 Replies
View Related
Apr 2, 2010
I have a web page that is not and will not be hosted on a web server. So no PHP, ASP solutions will work here. The method of access is File://. We only run IE 7/8 so no solutions that are firefox only. Here is what I want to do: Use javascript to build a table by reading a XML file stored in the same folder. When I try to use something like:
[Code]....
View 7 Replies
View Related
Jan 21, 2011
I am using a straightforward jquery.load() command which loads a set of html content into another HTML. I have tested this functionality across multiple browser from multiple computers in multiple locations, and it works fine, but for some reason within my client's office network, ajax content does not load. No browser errors are thrown. All I can tell is that within safari, for example, I will get a "cancelled" message in the activity log.
View 6 Replies
View Related
Jul 20, 2005
In my site I show low quality pictures. When someone right clicks an
image and selects 'Save Picture As...', I wish to let him save the
high quality picture.
View 5 Replies
View Related
Oct 17, 2011
I have text area that includes the full path for a local file on our company network. The files are usually excel sheets or docs. How can I have it so when they clicks the file it opens the local file?
View 4 Replies
View Related
Mar 5, 2009
I have made aa simple offline website to be used as an intranet. This is made up of an html file and a seperate js file.
While testing, i had the html on my c: drive and the one line js file sitting on a network drive (g - everything worked how it should.
I then put the html onto g: drive and find that the part that the js file controls no longer works...
All my file paths are the same and point to the right place but for some reason the js doesn't work.
View 5 Replies
View Related
Jun 29, 2000
When you right click on a link you get the option to save target as...(ie) and save link as...(netscape). Is there some JavaScript to call this function like the JavaScript to open a new window?
View 3 Replies
View Related
Feb 4, 2011
I am about to launch a SharePoint site with thousands of users accessing the site from a very, very slow network. Two questions. Is there a way to 'install' jquery so that it doesn't download every time they access the site?
_All_ users are on the same domain and are using IE7. Once they download JQuery on the initial page visit, does it still redownload the file every time they access the site? Temporary internet files don't get cleared after each session, so I'm assuming it doesn't get re-downloaded.
View 2 Replies
View Related
Dec 6, 2010
Code: //Define the class
class author{
function author(a:String,b:String,c:int)
{
this.name = a;
this.lastname = b;
this.age = c;
}
[Code]...
in this code the variable "newBook" to save the whole object, returns to save only the last one that was created...
View 1 Replies
View Related
Jul 23, 2005
Im supposed to write an activeX dll that will be called by javascript
(with the OBJECT TAG) and was wondering if its supposed to have any
special features or its a regular activeX dll.
Also I would like to know if it matters if its written in C++ or VB,
and if someone has sample C++ code that does this i will be grateful
to see!
View 1 Replies
View Related
Jul 20, 2005
I have a ActiveX object. This is working fine in English windows and IE, But causes IE to crash in Chinese windows.
View 1 Replies
View Related
Jan 6, 2010
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?code...
View 7 Replies
View Related
Aug 1, 2009
I am currently detecting for Shockwave within IE by doing the following:
var isInstalled = false;
if (window.ActiveXObject) {
var control = null;
try {
control = new ActiveXObject('SWCtl.SWCtl');
} catch (e) {
[Code]...
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.
View 1 Replies
View Related
Jan 6, 2010
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?
<script language="javascript" type="text/javascript">
function ExportToExcel() {
input_box=confirm("Export to Microsoft Excel?");
if (input_box==true) {
[Code]....
View 5 Replies
View Related
Jan 3, 2003
I thought I'd post this and see what you guys think (go easy on me :)). Anyway, my teacher gave the class a project to see if we could make a hangman game with an ActiveX object's draw methods and some good ole' DHTML. I've always wondered why javascript doesn't have any draw methods or graphics objects like Java has.
I suppose SVG will take the place of activeX and Flash... hopefully. Once we had the right object id it was a piece of cake (I found it by the way). Anyway, here's my program. I would've put the code in this post but I have a few includes and graphics that go with it. Best viewed in 1024 x 768 resolution, and IE only (of course).
View 2 Replies
View Related
Oct 31, 2006
I have a windows media file that I want to play on a webpage but the stupid activex content blocker keeps on poping up. I have heard that there is a way of getting around this or to preload the content. Does anyone know how to do this?
View 2 Replies
View Related
Mar 9, 2007
I built a form that utilizes arrays for storing data, prototype objects stored in arrays, and DOM using getElementByID and getElementByName. Now, in XP SP2 with the security center turned on, I get alerted by IE6/7 that there is an ActiveX script on the page and it asks to be allowed.
I don't want users IE to see this ActiveX warning. First, the users going to be using this form are not exactly tech savvy enough to know to allow it. Second, I had no idea JavaScript was related to ActiveX--which begs the question, what sort of things cause JavaScript to be flagged as ActiveX?
View 3 Replies
View Related
Jul 23, 2005
Is there any way i can show my excel chart on my web page.
View 2 Replies
View Related
Oct 22, 2005
How can I create a fade with javascript that fade an activex object
(quicktime) to the background and not to the IE windowed control.
I call this function several times, each time decreasing the "opacity".
id is the quicktime activex object.
I have tried to set background:tranparent and
background-color:transparent in my style sheet.
//change the opacity for different browsers
function changeOpac(opacity, id) {
var object = document.getElementById(''+id+'').style;
if (object.opacity) {
object.opacity = (opacity / 100);
} else if (object.MozOpacity) {
object.MozOpacity = (opacity / 100);
} else if (object.MKhtmlOpacity) {
object.KhtmlOpacity = (opacity / 100);
} else if (object.filter) {
object.filter = "alpha(opacity=" + opacity + ")";
}
}
View 1 Replies
View Related
Jan 14, 2006
i could create it successfully, but i can't manipulate it
<html>
<body>
<object height="50% width="50%" classid="clsid:XXXX....." id
= obj>
<script language= javascript>
obj.gridVisible= true //the method call here
don't take effect
</script>
</body>
</html>
here is the interface i implemented in my control
interface IControlInterface : IDispatch
{
[id(..), propput]
HRESULT gridVisible ([in] VARIANT_BOOL bVal);
}
anything wrong?
View 1 Replies
View Related