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.
No, I can't say that what you require is possible as I have not tested the same. Just wanted to know if you have SSO set up. Because if yes, then we know that it still does not work, but if there is no SSO, then that option could be explored.
As SSO is set up in our system, in SU01 for a user I can see a tab called SNC where the SSO settings are made.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.