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
Bookmarks