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?
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).
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:
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....
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?
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.)
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.
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.
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.
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.
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?
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?
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:
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?
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.
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?
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.
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.
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.
