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 Replieswhen 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?
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 Relatedis 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 RelatedThe following code can generate excel file,however i discovery that if there are more than one user load is asp,only one user can load it sucessfully.If the 1st user have already load it,when the 2nd user load it,the 2nd one can load it while the 1st user 's page will be disappeared.. Code:
View Replies View Relatedwhat will be the code for making graph with excel through asp?
View Replies View RelatedI 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:
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
Our ASP's stopped opening, and we gewt the error, page not found.
View Replies View RelatedI 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:
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.
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???
how to open port 80 so that I can access my website from other computers?I am using Xp professional.
View Replies View RelatedI 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
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 ....
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 Relatedin 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.
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?
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?
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 RelatedI 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 RelatedI 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 RelatedIn 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 RelatedI 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.
I want to open a new window from ASP page, which may not inherit sessions values from its parent.
I'm opening a new window (JS:window.open) from an ASP page, the child window inherits all the session variables from parent (thats what i dont want). and if I write session.abandon in the child ASP file, it also destroys the parent 's session values.
how I can open an ASP page in new window which doesn't inherit sessions from parent.
Recently, when I try to open files in web projects with visual interdev 6 I get this error message:
Server error: Error 2 opening registry key Software/microsoft/shared
tools/web server extensions/ports/port 80 .
Well, just in one project I can open its files. I don't know why is the difference between this project and other projects.
I'm on a project for a government application. For a given domain object, there is a report that is pre-generated, converted to PDF, and stored in the database.
The client wants to have a list of these domain objects, each one with a print icon at the end (which is already done).
The problem is when they click on the print icon, a postback is acceptable, but basically they want to hit the database, download the PDF, stream it to the browser, and print it, all without any pop-ups.
In short, other than the blink of a page for a post-back, they want Win App functionality of clicking print, and a PDF printing without any other interaction (downloading the PDF, file-> print, etc).
Since its a PDF, I know this isn't possible with Javascript. I have no experience with ActiveX whatsoever, so I was hoping for advice on whether this was completely impossible, and the level of effort involved.
I think its impossible, but I want to at least say I've done my homework before I tell the consultant that who thinks it can be done.
I am coding in ASP. When there was an error in my code, it used to come up in IE and tell me the error and the line of the code it was on. Now, it's opening Script Debugger on the server all of a sudden, and I no longer see those errors in IE. Does anyone know why this is happening and what I can do to stop it?
View Replies View RelatedI have a field in the table that saves pdf file paths:
there are 2 records like this:
/docs/one.pdf
/docs/one&two.pdf
what i do is display the paths on the page and when people click on it the file is opened
this is how i display the paths
<a href="<%=RS("Path")%>"><%=titlename %></a>
the first file one.pdf opens up
the second file one&two.pdf doesnt open up
if i change the name of the path in the table to
/docs/onetwo.pdf it works
so i found out the & is causing the problems
can someone tell me how to fix it.
I have a Windows 2003 server running IIS 6. On the server I have about 100 websites. I want to place a file on the server and have ALL sites include it on a web page(s). I tried this
<!-- #include file="C: est.inc" --> but it comes back File can't be found.
Done something with php and C/C++ sometimes. Problem:
I'm making intranet to my office and would like to open files from intranet (shared ms-net) directly to excel.
if I use a-tag those files open to IE and are read-only. I asked some ppl and they adviced to use header (theverychap from phpfreaks did this with php and it worked fine) but I can't get IIS to work right. Code:
i'm looking for a way to simulate, say, 10 simultaneous connections to an especific Web page, i'm using ASP and Javascript, this is the code:
<%
for i=1 to 20
%>
<SCRIPT LANGUAGE="javascript">
<!--
window.open ('http://www.thepage.com')
-->
</SCRIPT>
<% next %>
The problem is that the "for" opens consecutive windows, not simultaneous windows. Is there a way to achieve this using ASP and Javascript?
I just made a simple web site using Frontpage 2003 with a simple MS Accesss
database.
IF I try to open the asp page in a browser by typing
http://localhost/mysite/db.asp it opens just fine
However if I try to opeb it by typing c:/mysite/db.asp I get the following
error message:
The Database Results component on this page is unable to display database
content. The page must have a filename ending in '.asp', and the web must be
hosted on a server that supports Active Server Pages.