Hey everyone, I am working on a file with 10 tabs that each have an essbase data set in them. Right now I have a macro that goes through and refreshes all of the essbase data sets but I am trying to find a way to incorporate a refresh date into it (whether it's displaying it in the essbase pull or pasting the date stamp in a different cell, I'm not sure). I know that I can just put a date stamp into a cell for each set while the macro is running but that doesn't actually validate that the Essbase pull was "Actually Refreshed". Maybe Excel and Essbase don't cooperate in this way but does anyone know of a way to pull the refresh date/time for a data set from Essbase? Any help will be greatly appreciated. Thanks!
Bookmarks