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.
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?
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.
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 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.
I have one text field in MSSQL that holds the entire text article, and I would like a stored procedure or a function to break the article into pages based on the character limit per page. However, I don't want it to break into the middle of a word. I can then use NEXT/PREVIOUS to navigate the pages.
I have a for loop inside the loop I am populating a schedule table...I need to place a page break after each table is created that way When one prints each schedule table it will be on one page.
I am using a SQl query to get information by company departments for a Dept Mgr. How can I display each dept on a seperate page. ie page 1 is dept 1, link to page 2 ect
I have say 100 records. I am displaying 10 records per page with 4 columns each per row. And i am able to force page break after 10 records on all pages. Noe one column contains dynamic content. So if the dynamic content is more the page is filled with data.
If the dynamic content is less, the page is not filled completely. So is there a way to check number of lines per page and then fill in the remaining page with another record. In brief displaying records based on page height and then force a page break.
I have a login page that Test's for the username and then tests for the password. If these test true then I redirect them to the member area. What I want to test for is if there is 1 user logged in with Session("test") = 1 and another user logs in with the credentials to set Session("Test") = 1 then the first session will terminate. The new user will then be able to navigate the member area.There will also be other user on with a Session("Test") = xxx where xxx is the Primary key of the validation table.
I'm using sql server 2000 database and trying to access it using asp. when i installed sql server, i selected the mixed mode of authentication(windows and sql server). Code:
I have a page which works fine testing locally on my win XP PC, using an access database file. When I place it on the server (all code and database file being the same)... it gives an SQL error :
Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E10) [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 2
I've been trying to create a test site - The site uses ASP with VBscript and talks to SQL Server 2000. I was able to complete and test it on my locally on my computer using Microsoft’s IIS 5.1. The website communicated fine with the database on the webserver/network server
However, when I tried to save the site from my local computer to the wwwroot folder in the server’s IIS hoping to make the internal site available to everyone here the resulting error comes up when we try to open a page with a recordset connected to the database: -
Our Error: - Microsoft OLE DB Provider for ODBC Drivers (0x80040E4D) [Microsoft][ODBC SQL Server Driver][SQL Server]Login failed for user 'AUMBSDDSSIUSR_AUMBCOMP'. /mysite/htm/test2.asp, line 8
The following "Send Page" Script Breaks w/Win 2000 & Outlook XP with the error ""The command line argument is not valid. Verify the switch you are using." However, it does work with win98 and Outlook Express. Any ideas on the problem? Code:
I'm using formmail.asp which is an emailing utility. Basically, the user fills out a request page, clicks "Submit" and the page posts to formmail.asp which emails the user information.
I'm running IIS5 on a Win2k server box and recently ran the Windows Updates (the last time I do that). Anyway, that emailing form doesn't work now on any of the sites I host. Any ideas?
I am planning to design a database (destined for the web) that will have between 20000 and 45000 records in it and will receive a lot of reads but very very few writes (just from me).
Now the question is should I use:
1) The combination of Access 2000 (accessible through ASP or ASP.NET) using OLEDB Jet
or
2) SQL Server 2000 ?
Of course I know that the SQL Server option is a better one, especially since it's said that an Access DB can have about 9 users or so accessing it at the same time. But is that a general rule or is it about many people writing to the DB? In other words, if an Access DB has hardly any writes and 99.9% reads can it be used as efficiently as it would be used on SQL Server 2000?
I have one 3 tier architecture application running on Windows 2000 Server.
I have created replica of same machine on another machine where OS is Windows 2000 Advance Server.
But when I port same running application on new machine i.e. Machine with OS as Windows 2000 Advance Server, my middle tier (Active-X Dll, COM+ application) fails.
It throws common error Invalid Procedure Call or argument
What could be the problem? Do I need to change any settings for running application on Windows 2000 advance Server.
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.
am creating a asp page that wiil fetch data from database and export that to excel. not using excel objet, am creating a HTML table to display the data. Now that it displays the data correctly in IE, I want to it to be stored in excel file too.
If I create a file in code, it creates the file. But the file shows up 0 bytes. and holds nothing. Anybody pl guide me how would I redirect my output to the excel file.
I was having a go at importing a page written using HTML embedded with some ASP and SQL commands into an Excel sheet.
Now I have tried using the command below and no luck. After doing some Google searching I found some people suggesting removing HTML and BODY tags which I did but no luck. Tried using HTML and BODY tags and still no luck and all of a sudden I hit a brick wall. Code:
What would be involved with having an Excel spreadsheet displayed in an ASP page? The additional problem is that the file name changes on a monthly basis. For example, this month's file name is 'Feb 2005.xls'.
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.