Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I have a simple code, generated by Macro Recorder:
With ActiveWindow .SplitColumn = 1 .SplitRow = 1 End With ActiveWindow.FreezePanes = True I need to execute it from external program in VB6. When I for example fill a cell, I do: clsExcel.GetExcel.Sheets("sample").Cells(x,y) = z But where to bind ActiveWindow object? I tried several possibilities, but without success... |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to iterate through sheets and set ActiveWindow | Excel Programming | |||
VBA ActiveWindow.WindowState Problem | Excel Programming | |||
Problem with using the ActiveWindow property - sometimes | Excel Programming | |||
ActiveWindow.ScrollColumn Sort | Excel Programming | |||
Using ActiveWindow.PointsToScreenPixelsY | Excel Programming |