I'm looking into using this too. I can basically re-create it without the source database, but since my application is not public, Excel gives a spreadsheet full of blaks because it's trying to export the login page.
We use Single Sign On which is absolutely critical. Our users complain if we change the type face ... can you imagine if the had to type in their username-passowrd again? Oh the humanity!
Anyway, is there a way to bypass the credentials required since the user is already logged on?
I will be using Jake's original method for now, although I find the external data query much more elegant.
I'm looking into using this too. I can basically re-create it without the source database, but since my application is not public, Excel gives a spreadsheet full of blaks because it's trying to export the login page.
We use Single Sign On which is absolutely critical. Our users complain if we change the type face ... can you imagine if the had to type in their username-passowrd again? Oh the humanity!
Anyway, is there a way to bypass the credentials required since the user is already logged on?
I will be using Jake's original method for now, although I find the external data query much more elegant.
Luc Millette