shortcut keys

[dstiefe]

I wanted to know if their was a way through VBA to simulate using the
shortcut keys

I am trying to loop through several sheets and kick of essbase to retrieve
my data

and given i have 50 sheets i was wondering if i could write something in VBA
that would simulate selecting the sheet and then kicking of essbase

Thank youi

 

[Simon Lloyd]

You can use the sendkeys method however it's not always 100% reliable


I wanted to know if their was a way through VBA to simulate using th
shortcut key

I am trying to loop through several sheets and kick of essbase t
retriev
my dat

and given i have 50 sheets i was wondering if i could write something i
VB
that would simulate selecting the sheet and then kicking of essbas

Thank youi


--
Simon Lloyd

Regards
Simon Lloy
'Microsoft Office Help' (http://www.thecodecage.com)