LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

How To: Programmatically Scroll Excel

Hey all,

I'm getting more familiar with ActiveX and its use, however I'm stumped on finding a way to do this.  Has anyone ever programmatically scrolled an Excel worksheet?  Maybe I'm looking in the wrong spot...  Would I be able to find how to do this in the Windows API?

Any thoughts/pointers are much appreciated.
0 Kudos
Message 1 of 4
(7,340 Views)
Hi Will
 
Whenever I am unsure how to do something with Excel in ActiveX, I record a macro in Excel. I then go look at the code in the VBA editor.
 
Sub Macro1()
'
' Macro1 Macro
' Macro recorded 15/11/2006 by _
'
'
    Range("A1").Select
    ActiveWindow.ScrollRow = 27
End Sub
 
As you can see its possible all you need to do now is translate that to G Smiley Wink
 
cheers
 
David
 
Edit: Grammar

Message Edited by David Crawford on 11-15-2006 05:19 PM

Message 2 of 4
(7,339 Views)
Ahh, thanks very much.

That's a useful piece of advice too.  Wish I'd thought of it 🙂

This will get linked in the Excel thread.

Thanks again David.
Message 3 of 4
(7,333 Views)
And just for reference...


Message Edited by Will.D on 11-16-2006 08:23 AM

Message 4 of 4
(7,308 Views)