View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jerry Scannell Jerry Scannell is offline
external usenet poster
 
Posts: 1
Default 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