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.
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?
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.
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.
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.
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.
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.
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.
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?
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?
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....
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.
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.
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.
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?
I want to call ASP object from VB component. When my component is ActiveX dll I can get the request object and read the form controls without any issue. But when my component is ActiveX exe the same code doestnt work Does Activex EXE support accessing of ASP object model.
I was wondering if you guys know if there is a good component for sending fax? the server has a fax-modem and i would like it to "call" an other fax and send data. is that possible?
I don't know to much about asp in general, I'm an ASP.net developer, but my boss wants me to find out the following:
Is it possible to use a COM component from ASP. We have a COM component that allows us to interact with our bank for e-commerce style functionality. Our current site uses ASP and we know need to integrate this COM component in order to let us to some fancier stuff, such as on the fly fraud checking for credit cards.
Can someone advise me if ASP can use COM components and what is involved? Does anyone know of any good resources such as a tutorial?
I build a (vb) component for use within in an ASP. When I put the component in Component Services on the server it will not work if there is no one logged in to the machine. How do I remedy this?
I have downloaded thia DLL that you register then can use the asp object coded into it. can someone give me more information on these component DLL's ?
We have been having problem with our file upload component. It seems that at times the file upload process hangs, and the users get a timeout error. Although the users upload 1 or 2 image files at a time.
I have altered the upload size limit property in the IIS 6 metabase properties, so I don't think that is the case. Because most of the time it works okay, but at other times it hangs....
I have created an asp page that pulls data from SQL server and displays on webpage in the form of Table and Chart.
I use OWC to generate Chart. It work find on my computer with Ms office 2000 installed, but when I upload my the page to my webserver, it doesn't work with the following error message:
006~ASP 0177~Server.CreateObject Failed~Invalid ProgID. For additional information specific to this message please visit the Microsoft Online Support site located at: http://www.microsoft.com/contentredirect.asp.
Does anyone know how to solve this problem?
P.S. On the production server, Office Web Component had already been installed. WSCript.CreateObject("OWC.Chart") works fine in my colleage's vbscript file.