i have set up something similar to that in a macro, but trying to get around having the retrieval in a macro. Users are going to be hitting the refresh button in the smartview tool bar and would like to add the stamp through that somehow?!? Or, if someone retrieves a tab excel automatically stamps it.
this is what i currently have:
Declare Function EssVRetrieve Lib "ESSEXCLN.XLL" (ByVal sheetName As Variant, ByVal range As Variant, ByVal lockFlag As Variant) As Long
Declare Function EssMenuVZoomIn Lib "ESSEXCLN.XLL" () As Long
X = EssVRetrieve("Essbase", range("A1:O15"), Empty)
range("c20").Value = Now()
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True