Prev: Possible disregard formatting in exception match code?
Next: Non-matching cells
From: dstiefe on 5 May 2010 23:49
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
From: Simon Lloyd on 6 May 2010 02:45

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


d
s
t
i
e
f
e
;
7
1
7
4
0
1

W
r
o
t
e
:


>
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/showthread.php?t=200883

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Possible disregard formatting in exception match code?
Next: Non-matching cells