hi

Having looked in Excel Help>ESSBASE Help> Macros>essRetrieve ..I found the following syntax to retrieve data from ESSBASE into Excel 

Please Login or Register  to view this content.
From this I have written the following;

Please Login or Register  to view this content.
which doesn't work.

Q1. any suggestions to fix?
Q2. what syntax do I use to retrieve data into multiple sheets in the same file (eg sheet2, sheet3, sheet4 etc..)

Thanks in advance
Conor