Skip to Content
author's profile photo Former Member
Former Member

Logout Using VBA

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

Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 06, 2006 at 12:26 PM

    See the below link

    BW Automation: Disconnect from BW Server

    Regs

    Gopi

    Assign point if it helps ...

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      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.

  • author's profile photo Former Member
    Former Member
    Posted on Aug 03, 2006 at 10:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded