P
Paul Wagstaff
Hi folks
(Office 97)
I am attempting to automate Excel from within Access. Specifically, if I
write:
Range("F4").Select
ActiveWindow.FreezePanes = true
...my wsh splits both horizontally and vertically. However, if I run this
code from within Access, automating Excel, the wsh only splits vertically.
Needless to say I need the former.
TIA
Paul
(Office 97)
I am attempting to automate Excel from within Access. Specifically, if I
write:
Range("F4").Select
ActiveWindow.FreezePanes = true
...my wsh splits both horizontally and vertically. However, if I run this
code from within Access, automating Excel, the wsh only splits vertically.
Needless to say I need the former.
TIA
Paul