shortcut keys
 

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

shortcut keys
 

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