ASP Working With MS Office
I want to read the MS Word and XLS documents with ASP code for searching. Is
there are any solution for me or any reference?
ADVERTISEMENT
Office Web Component
Using OWC version 2000 I am trying to input a recordset
into an OWC Spreadsheet. I can pass the variables and
create the SQL fine in the ASP page, but I need to pass
the SQL to a vbscript function outside of the <% asp code %[color=blue]
>. Is there any way to call the function? ASP doens't seem[/color]
to recognize the function.
ASP To EXCEL In Office 97
Im creating an Excel file using ASP
Versions : Office 97
The formattting is not working properly in Excel 97, but the same works fine
in Office XP & 2000
Is there any additional code has to be added in my code to get a formatted
output in Excel 97 version?
Office Page
Does anyone now were I can get a script for an out of office page for an intranet. A very basic one would do, something that displays when they leave and other basic details,for a company of about 40. All staff would be using it.
View Replies View RelatedSaving .Doc (office) File
I have to allow users to download files after checking users validity and I
cannot give full URL of file to download e.g www.myserver.com/mydoc.doc
I have seen ASP code some where in MSDN where users has to enter URL like
www.myserver.com/mydoc.asp and this will download the doc file.
Graphs And Office Web Component (OWC)
I'm trying to use Activer Server Pages (ASP) to display a graph based on user's selection criteria. To achieve this, I would like to use Office Web Components (OWC 9 or 10), a Microsoft ActiveX component. My questions are:
* Can you use it with NT operating systems or Must it be in Windows 2000/XP?
* Do anyone has experience in using it? and if yes, Are they easy and reliable to use?
* Are there any other free components out there?
Office Chart Component
any decent resources for using the Office Chart components? I've had a look around the MSDN but it's not very comprehensive and doesn't actually have any reference guides. Most resources say to refer to the help file that comes with the package but I can't find any versions of this.
View Replies View RelatedOffice Web Components Documentation?
some good detailed documentation (with examples) on programing OWC (Spreadsheet, Pivot Table and Chart controls) using ASP 3.0?
View Replies View Related(OWC) Office Web Component Paremeters
I am using OWC to resize images on the fly, it works a treat only issue is poor quality images with lots of artifact due to high compression.
I have searched the web high and low for a list of parameters but I cant find any useful information on the object.
I was hoping someone has used it before and can tell me where I can get the right info on export quality using the .ExportPicture command. Code:
Accesing Office Document Properties With ASP
Does anyone know of a way to access the document properties of an office
document using ASP? I need to be able to read things like the Title,
Author, and Comments fields and pull that information into a web page.
Connnect ASP Page To Office Thesaurus
Is it possible to connect and asp page to the Microsoft Office Thesaurus? I would like to be able to pass a word to it and get back all of the synonyms as either a string, array, or collection.
View Replies View RelatedGenerating Charts Dynamically Using A MS Office DLL In ASP
I have found a Help and Support for How To Use Server-Side Charting to Generate Charts Dynamically in MSDN;
http://support.microsoft.com/default...b;en-us;244049
I have generated Bar, Line and Pie charts using the MSOWC.DLL and its fantastic.
The ONLY problem I have encountered is when generating Pie charts it shows the quntities of each piece inside the Pie chart and its very hard to read. But in Excel it shows outside the Pie chart. So, I want to find out a solution for this.
View MS Office Files Online
Are there any asp scripts that I can use to allow people to view my powerpoint, excel, and word files over the internet without having to download then? The must run from the server.
View Replies View RelatedServer-Side Automation Of Office
I am facing some problems with generating the word documents usin ASP pages. This is the automated process and it is breaking often Since Microsoft is not providing any support for this issue, I though using WordPerfect 12 for the automated document generation would hel me a lot. Is there any possibility of facing the same problem with wor
perfect too?
Access Metadata From Office Files
How easy is it to access the metadata from office files and PDF's? That is, Author, Title, Keywords, Comments etc...
I want to be able to scan a directory and provide links with descriptions (ie Comments field) for each file within. I can use automation to open and read the office files, but I imagine this would produce too big a load on the webserver. Is there a simple and slick way of doing this?
Office 2000 SP3 Excel Page Break
Since I updated Office 2000 to SP3, my ASP code has failed when executing this function:
(the HPageBreaks.Add line fails)
function insertPageBreak ( xlsObject, strLocation )
with xlsObject
.Range( strLocation ).Select
.ActiveWindow.SelectedSheets.HPageBreaks.Add .Range( strLocation )
end with
end function
Parameters:
xlsObject is a valid object of excel created with:
Set xls = CreateObject("Excel.Application")
strLocation is a string in the form "Axx" where xx is the current row number, e.g. "A54"
I had to uninstall and reinstall Office 2000 without service pack 3 in order for it to work....
Office Web Components :: Save Changes In Excel File Via Web
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 RelatedKilling Winword.exe Process And Office 2003
I'm having difficulty getting winword.exe processes to die on our
development server when using
SET objWord = CreateObject("word.application") from an .ASP page.
This problem exists on our development server only as we are still
using Office 2000 components in production. No probs in production with
the current code which has been in use for a couple of years now.
I have to get these ASP pages working with word 2003 to avoid a rewrite
of a few applications.
I've tried using objWord.Quit and setting the object to "Nothing" but
it has no effect on the running process on the server.
Both development and prod servers are Win 2003 Server.
Copy/Paste From Office Web Components Object In Web Page?
I have a dynamically-generated asp web page which uses Office Web Components
to display an Excel bar chart of the user-selected data. The page works
fine, but the users would like to copy-n-paste the displayed bar chart from
the web page and insert it into an email (MS Outlook) or report (MS Word or
MS PowerPoint).
Is there any way of supporting this copy/paste functionality? When you
right-click on the chart in the displayed web page (viewed with MSIE6), you
are only given the pop-up button [About...] which displays the "About
Microsoft Office Web Components" splash window ("Version 9.0.0.8028 SP-3"
etc.)
Currently, the only work-around is to "Print-Screen", trim using Paint, and
then paste into the destination. This is too tedious and beyond the
capabilities of some of the users.
Office Web Components :: Excel :: Unable To Create Merged Cells
One of my programmers is using Office Web Components in classic ASP to create, fill and format an Excel spreadsheet. Everything is fine except when he creates Merged cells the performance drops dramatically. He has investigated the 'Center Across Cells' alternative but cannot get it working
using Office Web Comonents.
Has anyone come across this problem or even better has a solution?
ASP Not Working Ok In PWS
I just installed PWS on 2 machines (XP & 98).
The problem is that I can run the ASP files in the wwwroot folder when I use http://localhost from my browser or RUN (and that's for the default.asp). But the asp files do not work when I call them from a hyperlink in an HTML file.
CDO Is Not Working
After I moved the site to new server the mailing method stoped working , the cdo pull the email from sql database on the same server .. although it says sent to # recipients.
I send a webpage (newsletter) exisit on the server "I use full url" also the registration page gives when registration the error: CDO.Message.1 error '80040218'
Unknown Error
/extra/news/reg3.asp, line 251
line 251 is objSendMail.CreateMHTMLBody "http://www.example.com/newsletter.html"
I saw description of the error it sayes that I have to use full url ...but I am using it ...
any Idea ...
Asp Working Or Not
I have a sever 2003 machine of which I am trying to host a webisite on. The webpages I uploaded has lots of .asp files that could not be open. I'd contact the website disgner and complains about it and an he blaims it on my server not supporting asp technology.
My question today, is there a way to test what the problem really is?
FSO Not Working
In my serverside script I have gone down to the bare bones and the following doesn't seem to work:
dim fs
dim fst
dim LineOut
set fs = Server.CreateObject"Scripting.FileSystemObject")
set fst = fs.CreateTextFile("C:TEMPhome.tmp",True)
lineout = "MAFFIdentifier" & vbtab & "Title" & vbtab & "Initials"
fst.writeline(lineout)
lineout = " ==================================================
========"
fst.writeline(LineOut)
fst.close
set fs = nothing
The server gets to the end since I place a response.write in to test.
If I cut and past this into VB declare the variables as objects and lineout as string and remove the "Server." from the line when setting fs, then it works fine in VB.
Not Working In PWS
The problem is that I can run the ASP files in the wwwroot folder when I use http://localhost from my browser or RUN (and that's for the default.asp). But the asp files do not work when I call them from a hyperlink in an HTML file.If I do that, all I see are the contents of the asp file.
View Replies View RelatedGetting Working
Just set up Dedicated Server Hosting with GoDaddy. I put a very simple ASP page in the home web directory and try to load it and get a very generic error. A simple HTML file works fine. Obviously it's a permissions issue or maybe some service is not running.
View Replies View RelatedSql Not Working In Asp
i got an sql sentence that is executed in toad without problem; returns 1 but when i run the sql in asp i get returned 0. Code:
SELECT COUNT(*) as st
FROM sest_sklepi
WHERE rok<(SELECT TO_CHAR(SYSDATE, 'DD.MM.YYYY') as b FROM dual)
ASP Not Working
New to IIS, Why will IIS 5.0 not server up my ASP web pages? I cannot even get to the help because it is an ASP Page. I get an error in IE that states "HTTP 500 Internal server error". I have looked in the configuration and cannot find anything related to ASP. What can I do to serve up ASP web pages?
View Replies View RelatedWhy Isn't My PWS Working
I'm having difficulties making PWS work. I have WIN98SE. It was working for a while but now it says:
Quote: Problem:
An unexpected error occured.
Solution:
Please restart the Publishing Wizard.
Working With Url
Im finishing up a content management system for a client. It works fine except the way they have the pages set its nessessary for someone to open each page made and change it to the new directory.
the script copys a folder from lets say
http://fake/templets
To
http://fake/user
so now we end up with something like
http://fake/user/smith
On the pages in smith is there a way to make the look at their url and strip off all but the /smith part?
Or maby someone could tell me what im trying to do is called and ill be able to do a better search online.
<>0 Is Not Working
Here are the scripts. interest is 0, but, it will not execute then clause. Why?
interest = round(rs("CURR_WORKING_INTEREST"))
response.write interest
if sizeworkint < 3 OR interest<>0 then CURR_WORKING_INTEREST2 =
left(rs("CURR_WORKING_INTEREST"),2) + ".000000" end if ..
ASPUpload Isn't Working
I just noticed my upload function isn't working since I have move the folders and files to different directory.
Now I get this error:
Error Type:
Persits.Upload.1 (0x800A003D)
Wrong Content-Type. Make sure you have included the attribute ENCTYPE="multipart/form-data" in your form.
/foldername/UploadScript.asp, line 54
line 54 is:
Upload.Save "z:
ewfolder"
I have given modify, read & write permission for IUSR_MachineName account on NewFolder and given Read & Write permissions in IIS.
I also included ENCTYPE="multipart/form-data" attribute in my upload form.
CDONTS Not Working
I'm using IIS 5 on a win xp machine for all my testing, before I upload to our live server. I've installed the SMTP service and it's running with no errors.
Dose anyone know anything about the above set-up not supporting "CDONTS.NewMail" for sending email using ASP..?
I get the following error message: "Server object, ASP 0177 (0x800401F3) Invalid class string".