![]() |
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