hi

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

 =EssRetrieve("[Sample.xls]Sheet1", SAMPLE.XLS!A1:G20,2)
From this I have written the following;

Sub Retrieve()
=EssRetrieve("[Sample.xls]Sheet1", Sheet1!A3:M27,2)

End Sub
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