ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Reported problems with Office 2000 Service pack 3 (https://www.excelbanter.com/excel-programming/322785-reported-problems-office-2000-service-pack-3-a.html)

Jerry Scannell

Reported problems with Office 2000 Service pack 3
 
I am using Active-X objects in my ASP application. Since we updated to SP3
of Office, my asp code breaks when I attempt to insert a page break into my
excel document.

I downgraded back to office 2000 vanilla, and the problem goes away. Here's
the code I execute:

function insertPageBreak ( xlsObject, strLocation )
with xlsObject
.Range( strLocation ).Select
.ActiveWindow.SelectedSheets.HPageBreaks.Add .Range( strLocation )
end with
end function


strLocation is a string like "A35"
xlsObject, is a properly created ezxcel object like the following:
Set xls = CreateObject("Excel.Application")

If anyone has any idea what's up with SP3, please advise.

Thanks,
Jerry


All times are GMT +1. The time now is 12:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com