Skip to Content
avatar image
Former Member

Skip Logon Screen

Can someone tell me if its possible to broadcast an excel workbook thru email and then have the user refresh or drill down in the workbook without having to login using the login screen.

Thanks

Richard

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    May 09, 2006 at 06:30 AM

    dont think about SSO here. it dosent fit for this scenario.

    your case can be addressed with other mechanisms but it wont be a good practice.

    Regards

    Raja

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Richard,

      VBA resides in Excel. So, whatever you do is (usually) workbook-specific. That's both the good news and the bad news.

      I am not sure that switching to Web reports will change the dilemma much. But, I'm not an expert on that subject.

      - Pete

  • May 08, 2006 at 07:22 PM

    Hi Richard,

    It is possible to skip log in screens if you have SSO set up, but not sure how it would work in this case. Is SSO set up in your system?

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Richard,

      I am sure that you are already aware of the VBA code which will automate log-in. And, of course, the issue related to this code, which is that SOMEHOW the user's ID and password need to be passed to the server.

      Most people think the only way to do that is to put the user's ID and password in the code, which is a security issue. This believe is not entirely true. But, it does have to be somewhere.

      If the user's BW ID is the same as their (Windows) network ID, you can read the user's ID from Windows (using the Win32 API function WNetGetUser).

      That still leaves the password problem. How much work do you want to do? You could create your own INI file (or, really, any simple text file) that would be on each user's personal hard drive and would contain their current password. That way they can access it, but no one else could (unless your system admins have access to user's hard drives, which is the case in some companies). There are other more sophisticated things you could do if your security rules make the text file idea unacceptable.

      If you like this idea and want some code samples for any or all of it, let me know.

      - Pete