Logout Using VBA

[Former Member]

Hi All,

we are using VBA for automated production of a standard form in all values of a characteristic.

the issue we face is that we have to logout from the system and to relogon again at midnight as we have Time dependant Master data and the query runs always with current date as keydate.

After midnight the qry run with previous Date as key date and the aggregates have been updated with the current.

<b>In conclusion , does anybody know how to disconnect using VBA?</b>

Thanks in advance

[Former Member · Accepted solution]

See the below link

Regs

Gopi

Assign point if it helps ...

[Former Member · Accepted solution]

I thought that question looked familiar!

Gopi, it is nice to know that someone reads and remembers.

- Pete

[Former Member · Accepted solution]

But I don't know whether Antony has solved the problem and I will be happy if it is and if I got some points.

I am new to BW but good in Microsoft. I am so fascinated with your replies and big fan of you.

-Gopi.

[Former Member]

Hi to all,

i would like to excuse me as i didnt reply to the solution you have given , as a personal problem kept me away.

The response time from you were fantastic.

'knowledge that is not shared is worthless'

Thanks a lot once more.

regards