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


dstiefe;717401 Wrote:

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

Regards,
Simon Lloyd
'Microsoft Office Help' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?u=1
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=200883

http://www.thecodecage.com/forumz