Hi,
i am using VBA for auto report refresh. for this purpose i need server date. how to get the Repository server date in VBA coding. i am not interested to use SQL query.
[involves VBA, therefore moved to SDK forum - Andreas]
Sasikumar.M
(BOB member since 2003-08-01)
Create a small universe, then use that to build a query. In that way you do not have to directly address the database via ODBC or some other fashion.
There is no direct method for VBA to talk to another server and obtain the date/time. But working with a universe and running a query should work quite nicely.
Dave Rathbun
(BOB member since 2002-06-06)