Boards
Rate my macro
Application.Goto Reference:="EssRetrieveEXP"
x = EssVDisconnect(Empty)
x = EssVConnect(Null, MyUser, MyPwd, MyServer, MyAppl, MyDbase)
x = EssVRetrieve(Null, Range("A1:N109"), 1)
Selection.Replace What:="No Data", Replacement:="0", LookAt:=xlWhole, _
SearchOrder:=xlByColumns, MatchCase:=False, SearchFormat:=False, _
ReplaceFormat:=False
Range("A1").Select
Pretty good eh? Does an essbase retrieve (Gotta love Essbase!) and then DESELECTS THE RANGE. I hope the speechmarks don't mess this up.
Share macros.