How do I code to retrieve on a hidden tab?

R

regals9

Joined
Oct 31, 2008
Messages
1
Reaction score
0
I have a file that I have created for users and I am able to get the retrieve functioning to work. I have been able to set parameters to unhide the worksheet and rehide the worksheet however when it rehides the worksheet Essbase has not completed its retrieve and goes back to the summary page.(which is not a retrieveable worksheet) The coding is below any help is greatly appreciated.

Application.ScreenUpdating = False
Sheets("DTActual").Visible = True
Sheets("DTActual").Activate
SendKeys AltKey & "(SR)", False
Application.Wait Now + TimeValue("00:00:01")
Sheets("DTActual").Visible = False
Application.ScreenUpdating = True
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Workbook_BeforeSave 8
Code execution is correct but generates Error :The file you aretrying to open is in a different form 3
Closing running sub from a different one 3
Excel Code to run ActiveWindow.View in normal view, only runs manually. 21
Workbook open code to do 2 things 1
Run macro on all files in a specific folder 3
Trouble with copy to newly created sheet 5
Set Active Cell to A1 on Open Q 3

Top