Details From SQL Server To MS-Word File
I have a strSQL line.. that basically does a SELECT * from many joined tables. The output is displayed into a table. What I'd like to do is, to have each table's field entries (say a Name field) displayed as a URL.
Clicking this URL will spawn an external viewer, which will open a predefined MS Word template. ASP code should then do a few SELECT statements, parse them, and write them to certain areas of the MS-Word document.
Practically, a user should be able to click on a name, and have MS-Word launch, filling in details on the Word document, such as Name, Address, ZipCode and so on, which are stored in SQL-Server 2k. how I can get this to work?
View Replies
ADVERTISEMENT
Is there a script ( without DB) I can use which can give the entire details of the server, including the root dir, folders info.
View Replies
View Related
Is it possible to run an asp script to display the details (i.e. last
modifed time/date) of several files held on the client and or on the server
running IIS (if i map it to the folder with the files in question).
View Replies
View Related
I've created a form for users to fill in, and I want to be able to write the details of each form to a text file. Each file is named username.txt (eg. JohnSmith.txt or MikeStiletti.txt)
However, when the code below is processed i get a "Path not found" error. Now these files are on a web server and i am trying to write to my C drive. It would be great if I could create these files on the same web server too by just removing the "C:Surveys" on the bolded line. Code:
View Replies
View Related
Can anyone tell me why this code doesn't work? The original came from
an example in this group, but was modified slightly when the original
failed to return message details.
I am able to connect to the server and see the number of messages on
the server, but message details (sender, subject, body, etc.) are not
returned....
View Replies
View Related
I have a folder that has a batch of leaflets in it, these are PDF files. In my application I have a list of courses and one of the fields has the name of the file.
Is it possible, without automatically having to add them by hand, to grab the file sizes and use them on a page or insert into the relevant db field?
View Replies
View Related
Any known COM objects or ASP-callable functions that will perform at least rudimentary conversions?(Word IS installed on the server, although I'm familiar with MS's policy on
using this.)
View Replies
View Related
I tried this code below and there is a problem in the code which is not closing the word instances in the server you can see that from Task Manager
STEP 1:
Code in test.asp.
<%
Set word = Server.CreateObject("Word.Application")
word.Documents.Add
word.Documents.Open(Server.MapPath("test.html"))
word.Documents(1).Close
word.Quit
Set word = Nothing
%>
STEP2:
Create a test.html in the same folder.
Execute the code in the server
http://localhost/test/test.asp
Is creating the 2 files WINWORD.EXE instances in TASK Manage every time we browser the test.asp page. This is creating the load on the server and making our application DOWN. I am a coldfusion developer working on ASP.
View Replies
View Related
I would like to know if I have a word document on asp, how would I read it's actual content rather than the binary data.
View Replies
View Related
I have problem in word automation. I have a code in VB that opens word document and performs some Find & Replace operations in it and then shows to the user the document. The script runs perfectly on local machine which has Word2000 and OS-win 2000 professional. But When I test the same script on Server which has Os-2000 server Edition and word2000 then it does not opens the word doc eventhough script has line "WApp.visible = true".
I am using Word.Application and Word.Document object in my script. When I create a word document with same script but close it in end of script and then open it with shell script command it works perfectly. But my requirement is not to save the doc but only show it to user and leave it for users choice to save it or not.
View Replies
View Related
I have a web application that enables a user to download a word or excel file. I want them to be able to edit the file and then when they close the file I then update the image that contains the file in the SQL database. This is all quite simple apart from I can not see how I can get the cotents of the file.
Things like "ActiveDocument.Content.Text" seem to work in word just for the text but I need to get the lot in order that I can then post it back to the webserver when the file is closed.
View Replies
View Related
I m working on the application wherein I am requiered to display the local word file from the client side on the client system.
I have tried it by redirecting to the file with the local path but it is giving the 'Access Denied' error.
View Replies
View Related
I am having trouble displaying a word file. Following is the code I am using.
Response.ContentType = "application/msword"
Response.Addheader "Content-Disposition", "attachment;filename=hostsfile.doc"
It opens Word but the page is blank. What am I doing wrong?
View Replies
View Related
I have manage to create a word doc from lotus notes using the createobject("Word.Application"). Now I wanted to add some text in a field on the template. I want to know how to insert a newline in the field.Also I have created a table in the doc file, now i wanted to know how to place at a desired position in the file.
View Replies
View Related
I want that when the user writes a story (some content) in the textarea...it sould get saved as a word file. Actually the concept is that the student writes a story in textarea and submits.
But when teacher views that story he should be able to open it as a doc file so as to make some corrections like strikethrough, highlight etc. So what I want is that the story should be saved as a doc file in database...can it be possible?
View Replies
View Related
Now I wanted to do some office automation in my web page. Let say I have the microsoft word named report.doc. In this report.doc , I wanted to put the number in header or footer from the parameter in my asp file. How do I do that?
View Replies
View Related
I need to search ms word file with ASP, and find a couple of predefined words. such as "apple" "mac" etc.
View Replies
View Related
I wrote a code that allow to open a Word document, and save it. Before it worked perfectly... but after changing the Server, it doesn't work anymore! Code:
View Replies
View Related
I have a pdf or word file on my server and i would like put a link or a button on my website to print it. So when i push the button the file should be printed.
The confirmation popup window i sno problem. So i am looking for something like window.print,but then to print a word or pdf file that i have somewhere on my server . Is this possible?
View Replies
View Related
I want to open word file in explorer. I am using hyperlink for this purpose but it doesnt show me the file opened. Though i able to do save as on it.
View Replies
View Related
I have an ASP page which needs to export some HTML content and images into a Word file.
Currently I am displaying the image in the Word file from the URL.
What I need is to stream the image into the word file alongwith the other HTML contents.
View Replies
View Related
How can open a Microsoft Word file by ASP?
View Replies
View Related
Just a thought...Using
Code:
Response.ContentType = "application/msword"
to save asp pages to MS Word, saves the text on the pages OK, but, pictures, icons etc are just saved as a link to the original picture file . If the picture/image is not on the current PC opening the WORD file, then none is shown..
I was wondering if I could save the asp pages WITH images/pictures & icons using MS WORD on the server and then the users downloading the .doc file from the server to their PC, would this embed the pictures etc in the .doc file, so it could be shown on any PC. (which has WORD or a WORD Viewer installed).
If this is possible could someone point me in the direction as to how to get started opening WORD on the server and saving the .doc file on the server.
View Replies
View Related
While i'm here, do you know how to select a random word from a text file?
Txt file is like this:
word 1
word 2
etc.
View Replies
View Related
generate an ms word file for an asp output?
<%
x=date
response.write(x)
%>
- is it possible for the date (code above) to be displayed on ms word?
View Replies
View Related
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?
View Replies
View Related
when a student logs in i want to create a Microsoft word (doc) file with basic information filled from database and rest of the info will be hand filled. how to get data from sql server and fill the .doc file with it.
View Replies
View Related
How can i convert the .fxm(fax) file format to any of editable file formats such as Microsoft word or excel.
View Replies
View Related
I want to open word file (or Excel) from IIS server (URL) without
getting security window for input Username and password. I know
Username, Password and Domain. I'm trying to open with:
http://domain%5cUsername:password@URL
When my computer is registred in this domain - no problem. But if my
computer is not from this domain I always get window for input
Username, Password and Domain.
View Replies
View Related
I have prepared a mail merge application in VB. Now i want the same to convert to ASP. how to go about it. I mean what class need to be used for that.
View Replies
View Related
How would this be done for something like a text editor?
For example, say I wanted to launch a text editor from a hyperlink AND also the file I wanted to open with the editor as as well?
View Replies
View Related
I have gotta a page in which a user can upload his profile (saved in word format). Is there any way that this profile can be stored into the database and not in the web directory. I tried using Scripting.Dictionary.
View Replies
View Related
I want to copy or upload a file from server say some lanserver to ftp server through ftp. Is it possible.
View Replies
View Related