I would like to open existent excel file and save it via ASP, I have to create save button to save opened excel cause I afraid that my user don't know path of saving. How can I do, now I open excel file on IE by <iFrame> and want to get data in <iframe> to save as excel file.
View Repliesi want to save asp created records to excel sheet by clicking a link.
link should be in same asp created page .By clicking link ,the populated asp records to be saved like save as option..At the same time i want to see asp records in html format .By clicking the link.
After a user make the search, it returns 100 rows of record on the display page. I want to give an option for the user to save the records as Excel spreadsheet. Like a small icon on the corner, it prompts to save if click.Can anyone teach me how to do it? or have a simple tutorial or code that i can see?
View Replies View RelatedI am developing my application in ASP and there is a requirement to save the output in Excel. One option is to use Content-Disposition header but it prompts user for saving. As per our requirement the output should get automatically saved.
View Replies View RelatedI have a webpage containing a link to a spreadsheet
<a href="somefilename.xls">click</a>
When the link is clicked a spreadsheet opens in internet explorer
using some sort of excel COM object.
I would like to enable the user to edit the spreadsheet and then
save the changes in the existing file. How ever IE only offers
"save as" not "save" and it dosent suggest the original filename.
The users already have write acces to the area where the excel
sheet is published. How do i make IE suggest the original filename
or enable the "save" menu??
Does anyone know of a way to take the records of my database and have it downloaded to an excel worksheet with asp???
View Replies View Relatedi have an ASP page which get data from DataBase. To save it as EXCEL I am using:L
<%response.contentType="application/vnd.ms-excel"%>.
What i want is to stop the user from editing some columns of saved excel file just like we pasword protect an excel.
I've got a simple recordset which writes a html table. I've put the following code at the top of my asp page:Code:
response.ContentType = "application/vnd.ms-excel"
response.AddHeader "content-disposition", "inline; filename=filename.xls"
...then done a response.write to write the table.
This should output an Excel file, but it doesn't? It just writes the table to my browser as a standard HTML page. Can anyone see how to solve this problem?
In office web components u can use Excel through web with almost the same functionality. I have an emergency in finding out if it is possible in asp to save the changes u make to the spreadsheet though web to the original file in the web server.
View Replies View RelatedDoes anyone know how to save an export excel file to the server automatically without any prompting and opening of the excel file?
Because I'm doing archiving, I need to let the user click on the archive button and the exported excel file will be saved directly to the server without opening the file.
I got a situation here, I have a web farm application, and I have a
requirement that I need to know the number of sessions opened on each web
server in this web farn design, I would appreciate if anybody can give me the
good thought.
For some odd reason I keep getting the following err msg:
Error Type:
MSAccess (0x800A1EBA)
Microsoft Access can't open the database because it is missing, or opened exclusively by another user.
On line 57 which is:
objAccess.OpenCurrentDatabase strDbName
I have strDBName set as
strDbName = "C:Test.mdb"
This is the correct name and the db is not opened I keep getting this err msg. Code:
I've built an email application which uses the 'ASPEmail' component to send mail to a list of around 3000 subscribers.
It's not possible with the stats software I have to track individual graphics - which would have been a good way to track the number of people who looked at the email. So is there any other way to do this tracking? Will javascript work well in mail clients, or can I embed a hidden iframe etc?
I have a document saved to a public network server. The public directory
grants change access to all users on the network. To keep my Word doc
protected I am using the Security feature "File Sharing Options" in Word to
attach a password to the document. This works as expected when users open the
file with Windows Explorer.
I also have an ASP web page that has a link to my file on the public drive.
When I click this link, the Word document loads without asking me for a
password and is not read-only. (Note the link in formatted with an href
attribute like this: file://servername/share/filename.doc)
Am I mssing something? Shouldn't the Word security work even if the file is
accessed through a hyperlink?
I am automating microsoft word from my asp page. It works fine but the only problem is that document1 keeps opened on my server.
Plz help me why do Document1 doesnot get closed??? Everytime when someone runs my application Document1 is there... So if 50 ppl execute this web page, there are 50 Document1 being opened and they remain open only... How to make it close???? Plz i need to do this urgently. This is mail merge sort of application.. This is my dll code:
I have to check wether the database connection is opened or not.I am using ASP with sql server database.
I can open connection and do all the transaction with the database,when multiple users are connected to that same sql server instance,i got an error like sql server not exist or access denide.So i want to check my status of the connection.
I keep getting an error that says:
Error Type:
Microsoft JET Database Engine (0x80004005)
The Microsoft Jet database engine cannot open the file 'c:inetpubwwwrootannoneil\_databaseannoneil_AN D.mdb'. It is already opened exclusively by another user, or you need permission to view its data.
/annoneil/artist.asp, line 96
The code was working fine a few days ago but now I cannot figure this out.
I have a page on our intranet that is supposed to stream an Excel sheet to
the user. I'm using pretty standard code:
I would like to have an option for my end users to do a SAVE AS. Is there a way to do this? I have a excel spreadsheet which is being created by asp and at the end of the page I would like to have an option to do a save as. so they can name the file and put the file anywhere they want.
View Replies View RelatedWorking with an asp page which pages through dates. If the
user saves one page as a mht file and pages to the next
day and saves the second page as a mht file, both files
turn out to be the same. It's as if I.E. 6 saves the
cached information, however if you open a new window and
save the page from that window it saves properly and the
cached information is available for the second window so I
think I'm on the wrong track.
i need to force a download to open save as dialog box rather than opening the doc in a browser.
View Replies View RelatedIs it possible to have line feeds/breaks automatically entered when the text wraps to a new line? I am using a <textarea> input on a form and using the <pre> tag when displaying the text to a html page (embedded in a .asp page). The text is being saved to a sql database. Returns seem to be displayed. But the wrapped text just displays as one long line.
View Replies View Relatedbeside save as htm and txt in IE , can i save as jpeg or other formats ?
View Replies View Relatedcan any one giv me some link or any helping material , how i can can pic in acces or sql database regarding by user ....
View Replies View RelatedI need to save a lot of pages to a .doc MS Word file with one button click on my asp app.... can this be done ?.....I am thinking this .doc file will be saved on the server, so I can then download it to the users PC.
I can have the MS Word templates to fill out on the server , so do i create an asp page to fill out these templates and then save the file..then somehow download it automatically, hence it will end up on the users PC in a shared Dir...is this all possible?
I would like to save a web page to a file. When I do that, sometimes
the saved web page does not look like the original web page.
For example, when I save www.msn.com, it looks very different the
original page.
How can I save the web page to look like the original (as if I do
"File" - "Save As" and under "Save as Type" select "Web Page, complete
(*.htm,*.html)" ?
This is how I save the web page:
Set fs = CreateObject("Scripting.FileSystemObject")
Set filePtr = fs.CreateTextFile("c:abc.htm", True)
filePtr.WriteLine (WebBrowser1.Document.body.innerHTML)
whats happening is i do a form post from a form "A", to a form "B" where
it does some processing and then does a form.redirect to form "C"..where
there is a link to the form "A". I only want that when the user selects
form "A" from form "C" then at least i should be able to display his
name and email address what he had entered previously.
what the best way to save the variables and when i display back in the
form how do know whether hte form is coming back or not?
is there a avaialble code in asp.net...
that have a similar function to Save as Dialog
When users submit a Form with a SQL query, the resultset is retrieved from a MS-Access database table which is then exported to an MS-Excel worksheet. After the records get exported to MS-Excel, I want to give users the option to download the Excel file to their local machine.
In other words, when users click a download link, I want the Save As.. dialog box to pop-up so that users can save the Excel file to their local machine (note that I don't want users to view the Excel worksheet in their browser). This is how I tried it: Code:
how to print with pre-define preference such as margin and page size ?
and a quick Question , the function call to save as
I have a PDF link in my flash site and want to force the Save-as dialogue to pop up when the link is clicked.
I've seen how this can be done by calling a php script, but my server only supports ASP. So was wondering if anyone had an ASP solution for doing this.
I would like to place a button on a web page that when clicked performs the same funtion as when you right click a link and choose "save target as..."the files I want people to download are .swf and I don't want to zip them.
View Replies View RelatedI have successfully been able to load text from an SQL-DB into a <textarea>.Now I need to save the edited text back to the DB But I can't seem to extract the value from the <textarea> into a vbscript-variable.
When the user clicks the submit button under the textarea I need the text to be saved into a variable, how?
Code:
<FORM METHOD=POST ID="Form1">
<TEXTAREA NAME="text1" ID="text2"><%Response.Write(Recordset("text"))%>
</TEXTAREA><br><br>
<P><INPUT TYPE="submit" VALUE="submit2" ID="submit3" NAME="submit4">
</FORM>