Hi,
I integrated a Microsoft Office Spreadsheet Web Part into our Sharepoint Portal Server. It gets its content from a link to a real spreadsheet file. In this spreadsheet file, I added some VBA code to jump to a particular part of the file, i.e.
Private Sub Workbook_Open()
Dim oRange As Range
With Worksheets(1).Range("b1:b500"
Set oRange = .Find(CDate(Format(Date, "Short
Date"), LookIn:=xlFormulas)
oRange.Activate
Application.ActiveWindow.ScrollRow = 129
End With
End Sub
When I test my code in Sharepoint Portal Server, the ScrollRow method doesn't work, meaning the active window of the web part doesn' t jump to the right part of the file. What is going wrong here? Can someone help me out please?
Kind regards,
Werner
I integrated a Microsoft Office Spreadsheet Web Part into our Sharepoint Portal Server. It gets its content from a link to a real spreadsheet file. In this spreadsheet file, I added some VBA code to jump to a particular part of the file, i.e.
Private Sub Workbook_Open()
Dim oRange As Range
With Worksheets(1).Range("b1:b500"
Set oRange = .Find(CDate(Format(Date, "Short
Date"
), LookIn:=xlFormulas)oRange.Activate
Application.ActiveWindow.ScrollRow = 129
End With
End Sub
When I test my code in Sharepoint Portal Server, the ScrollRow method doesn't work, meaning the active window of the web part doesn' t jump to the right part of the file. What is going wrong here? Can someone help me out please?
Kind regards,
Werner