April 29th, 2011, 03:53 PM
Essbase Retrieve All Code
I am trying to create a macro in order to be able to retrieve all sheets in a workbook. Here is a "loop through all" code I used. The problem is that I want to exclude 1 of the sheets from retrieval. How can I modify the following code to be able achieve that? The sheet I would like to exclude from the loop is called "Lookup" oe Sheet 1. Please help. Thanks.
Declare Function EssMenuVRetrieve Lib "ESSEXCLN.XLL" () As Long
Num_Sheets = Application.Sheets.Count
For y = 1 To Num_Sheets
x = EssMenuVRetrieve
Click Here to Expand Forum to Full Width
This is a Codeguru.com survey!