Opening Instance Of Excel Through Asp

when i try to open an excel spreadsheet using the
following code, the process just hangs IF the spreadsheet
contains macros:

Set objXls = CreateObject("Excel.Application")
objXls.DisplayAlerts = False
objXls.Visible = False
objXls.Workbooks.Open my_excel_path '<-- hangs here

this worked on iis4, but since moving this to iis5 it
fails under the aformentioned circumstances. my guess is
that the macro security has something to do with it as a
dialog box will pop up if macro security is set to medium,
but i'm not sure this is really the problem. if it was,
what profile should change the macro security on the
server? when task manager is opened on the server to see
the hanging task, it shows SYSTEM as the process owner...

any ideas?

View Replies


ADVERTISEMENT

Code For Opening Excel

Does anybody know some code that opens a spreadsheet in excel rather than the browser? If possible something that can be used with response.redirect, however this isn't essential. I have a script that creates an excel report, and people then open this report from a link. However I've been asked whether it could be opened in excel.

View Replies View Related

Got Error In Dll While Opening The Excel File.

I have created one dynamic chart creation application using vb dll. If I call this function from vb it is working fine. But If i call this function from ASP i got error while opening the excel file line. I have windows 2000 server. Do i need to give any permission for this? The same coding is working fine in NT server.

View Replies View Related

Opening Server-side Excel File Then Modifying It Client Side Using Vbscript

is it possible to open an excel file (used as a template) from server using server-side vbscript; then modify it or add values from client using client-side vbscript?

View Replies View Related

SECOND Instance

I have a script that looks for a phone number. I use an instr to see if
it finds a - for the phone number. I them grab the 3 characters before
and 4 after for the phone number. Works well, except when someone uses
the - in the text.How can look for the second instance of the - if the right 4 characters
past the - are not numeric?

View Replies View Related

How To Use Class Instance In Asp.net

I have a Class and i want to be able to use its instance
example
public class Enrolltest : System.Web.UI.Page
{
MyClass mc = new MyClass();

mc.mymethod();

}

when i do this i get an error telling me there is no name space what should i do .,,.
i dont want to create a dll and add it to assembly and all that stuff.

View Replies View Related

Creating An Instance

How to create an instance of Internet Explorer from classic ASP? I want
to create an instance of IE and then subsequently load a webpage through
this object.I am aware of creating web pages through scripting.
Long way to go before I sleep .

View Replies View Related

Another Instance Of Explorer

How do i lanch a new instance of explorer from withing a current web page.I want to click on a link that take me to a new page in another "window" so that when i close it i see the old window.

View Replies View Related

Display Only First Instance Of Record

.asp, vbscript, ms Access

I want to display a list of records on my page, like this:
California - Los Angeles - Sheraton
- Los Angeles - Meridian
- San Diego - Mercury
Colorado - Denver - ..................

ie. only display first instance of California..

Can this be done..

View Replies View Related

Instance Of An Object"

A three-tier user authentication system was running without a problem for almost a year and now is suddenly dysfunctional. We don't know of any changes to any of the servers. It's quite maddening. The details:

1) We know the COM+ app is instanced on the COM+ server (Win 2000). The component graphic spins when CreateObject is called.

2) The proxy is installed on an IIS server (Win 2000) with delivers the interface, written in ASP, to the client PC.

3) These are the error messages displayed when a method of DAMS is called:

View Replies View Related

Create Instance Of Filesystemobject

My server chokes when i try to use the filesystemobject. I'm running IIS v5.1 on XP Pro and it stalls when i try to create a text file or open one. Here's an example script that fails on the 3rd line.

dim filesys, filetxt
Set filesys = CreateObject("Scripting.FileSystemObject")
Set filetxt = filesys.CreateTextFile("C:InetpubwwwrootAIS estfile.txt", True)

filetxt.WriteLine("Here's the text...")
filetxt.Close

set filetxt = nothing
set filesys = nothing

Am not sure where to start troubleshooting .

View Replies View Related

Killing COM+ Object Instance

How to set timeout for COM+ object instance? If any instance is running more than 15 minutes, I want COM+ application to kill the instance automatically. Is there any way to set this?

View Replies View Related

Same Problem New Instance. Insert Radio

need inserting the radio buttons that are checked. Ok I'm trying to insert the user picks but i need help on first renaming each set of radio buttons so they can select one from each group then i need help on inserting the ones selected. Code:

View Replies View Related

Show Only One Instance Of Multiple Identical Items?

If I have 30 of the same cmpycd in the column, it brings it all up. I think this is one of those IF/THEN things, but not sure how to impliment it in the code.

All I want to do is show one instance of each unique item that exists in the cmpycd column. If it exists 300 times, I just want to show it once. Then also show the compFN that is also in the same row.

I can make it count and show how many are of each, but I cannot seem to get it to display just one of each. Code:

View Replies View Related

Opening A PDF

I have an application that returns a PDF document to the browser (not as a
download). The document is returned in a new window. This works fine in
most installations, but I have one installation where it doesn't work in IE,
but does work in Netscape. At the installation where it doesn't work IE
returns the file download dialog box instead of just opening the file. When
I click open or save it complains that it can't find the file. I suspect
the problem is with the file name.

IE is generating a very long file and
I'm guessing it is getting confused. My code did not originally set the
file name, so I'm trying to solve the problem by setting the file name.
Here's the code that I'm using, but it doesn't seem to have any affect.
Does anyone see why this doesn't work? objHttpConn is an HTTP control that
is used to retrieve the PDF document.

PS We are hosting the web sites where it does work and were it doesn't work
and I'm testing using my PC. The only difference is the version of the
application that returns the PDF document. All the machines are 2000
servers with IE 6.0 SP1. Code:

View Replies View Related

Opening UTF-8

I have a slight problem, I'm trying to open a textfile that has been saved
as UTF-8. But when I run it it displays strange chars eventhough i've
specified that it should read the file as UTF-8 using the OpenTextFile
method of the filesystemobject. I need to open the file, then insert data to
a database, nothing will get printed out on screen so its not a html-charset

View Replies View Related

ASP's Not Opening

Our ASP's stopped opening, and we gewt the error, page not found.

View Replies View Related

Object Reference Not Set To An Instance Of An Object.

We are using .net 1.1 on windows 2003 server. This is we are facing in our
production server.

When we are doing the load testing we are getting the bellow error. While
the load testing this error is not coming frequently. When we run 20 threads
for 3 mins we are getting this error message 2 or 3 times. But this line of
code is executed by all the threads. Code:

View Replies View Related

Opening OLE Object In ASP

I have a table called "Document" which has 3 columns

Doc_ID
Doc_Name
Doc (this is a word doc stored as an OLE object in ms access)

Now in my asp if the user selects a document it should open the word file.
I have my case statement that looks like as follows which I think might need some
modifications to open a word file: Code:

View Replies View Related

Opening A File

I have a drop down on a page where user selects a value and then a excel file opens up
it works good in mozilla but in IE it doesnt open up the excel file i see a new page been open but then suddenly it closes the file
i have checked the popus in IE and i dont know what the problem is
Here is the code Code:
<%
Response.ContentType ="application/vnd.ms-excel"
getid=Trim(Request.querystring("id"))
Response.write getid
%>
I see the output written when i use mozilla but it just doesnt work in IE.

View Replies View Related

Opening A New Window From Asp

I'd like to redirect from a certain page, to an external page(an external site), with certain parameters. of that window.

There is nothing to do if using response.redirct,
but is there another option?

For example, I would like to open a new window, that will have a cerain dimensions, and that the url of that window is... In javascript it is not a problem of course. What shall I do in asp???

View Replies View Related

Opening Port 80

how to open port 80 so that I can access my website from other computers?I am using Xp professional.

View Replies View Related

Opening A New Page

I have my code like this one.asp

<td><a href="callexp.asp?id=<%=rs("ID")%>" target="blank">View</a></td>

so now i call a diff page called callexp.asp ok

so it opens up a new page i want to set properties of the page like we do for pop up window.like i want the new page to be of a specific size with no scroll bars and stuff i have the code for opening a pop up window in javascript

View Replies View Related

File Opening

From a LINK or BUTTON on a webpage can we invoke the usual OPEN FILE dialog box that come with all the windows application .

In my Application I want to ASK the user the Name of a FILE on the disk ... currently i am asking the user to input the COMPLETE PATH in a TEXTBOX ....

View Replies View Related

Opening .csv File

I need to incorporate some emails that are in a csv file, all sorted in one column, into a mySQL database.I dont find the way to open the CSV file in ADO

View Replies View Related

Page Is Not Opening

in my database customer name is mike o'lee, i am creating one reason forum by using asp script and call customer name from database by using link syntax. when i trying to open the reason forum it displaying the error message like page is not found.

The problem is in single quotation which is present in customer name.I now how to remove the single quotation ,but use want to see the same customer name. how i can open the page,by using same page.

View Replies View Related

Opening New Window

I have this code

response.Redirect( "/mailer/TestPDF.asp?referenceNo='" & checkRS("RefNo") & "'" )

but i want to open it in new window..how can I do it?

View Replies View Related

Opening Asp Pages

I donloaded a web application form the web which includes couple of asp files. So when I open index.html and click on the links to those asp files, instead of running the code inside, my browser tries to donload them.

It opens a save dialog box and asks me where I want to save this already existing asp files. Does anyone know solution to this problem?

View Replies View Related

Opening A New Window

How exactly do you get a window to open withing the current browser (ie) without it going to the taskbar as a new window. example password hint .

View Replies View Related

Opening A File

I have a configuration.txt file and would like to open that file in a browser for editing onclick of a button or hyperlink!! It is more than enough for me, if i just open the file as it is in a notepad itself, by clicking a link from the ASP code.

View Replies View Related

Opening DB Connection In ASP File

I am trying to open a DB connection in an ASP file (with an HTML interface). I have some idea how to do it, but I am not quite sure. It is linking to an Access DB. It is very simple, I am posting some data to the DB. Only one connection is needed to open.

View Replies View Related

OnClick Window Not Opening

In the following snippet of code, I can not get my openBrWindow command to work. Does anyone see anything that jumps out at them that is obviously wrong? Code:

View Replies View Related

Opening Linked Tables

I have an Access DB that has a linked table to a SQL Anywhere DB. When I try to access this Access DB, it prompts me the first time every time for username and password to the SQLA DB. This isn't a problem when it is just me that is working on development, however,

I figured MS would have something good to say about this issue, so that my users can use this DB as well. MS says I need to pre-open the table using the same credentials for both DB's. I have tried this several ways, and am still unable to open the linked access DB.

The error I get is that the DSN=xsellvehicles (this is the DSN that is used by Access to open the table that resides in SQLA) can't be used because the username or password doesn't work.

View Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved