Excel macro to time stamp upon essbase retrieval

[supershot0015]

Hey everyone, my very first post (of many)!!

Hoping someone can help me come up with a macro that will time stamp a sheet upon the retrieval/refresh of essbase smartview?

thanks,

Brent

 

[Soggy]

Are you retrieving via a macro?

If so then add:

Range("a1").Value = Format(Date, "DD-MM-yy HH:MM")

where A1 is where you want the timestamp to appear.

 

[supershot0015]

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
Sub Retrieve()
X = EssVRetrieve("Essbase", range("A1:O15"), Empty)
ActiveSheet.Unprotect
range("c20").Value = Now()
ActiveSheet.Protect DrawingObjects:=True, Contents:=True, Scenarios:=True
End Sub

thanks soggy...

 

[Soggy]

To be honest I never dabbled with the add-ins on Essbase or smart (really didn't want to corrupt them).

I had set up a few sheets that will retrieve across numerous tabs and have it formatted, unfortunately I don't work with essbase longer so I can't have a peek either. Sorry