M
mleptuck
Hi all,
I've been tasked with automating a spreadsheet for the boss that needs
to pull SQL data from one of our DB servers, and then format and
import into Excel. The mechanics of doing so aren't the problem.
I want to know how I can securely do this over the web. We'll have
multiple users of this sheet all over the country, and ideally they
would:
1) open the .XLS file
2) press the button I've got a macro tied to
3) the macro goes out and runs the SQL query, and dumps the data into
the sheet
The problem is, the macro contains a credential set for a SQL account,
and while the VB code is password protected in the sheet, the sets
will be traversing the web, open for anyone who cares to look for it.
We've an SSL VPN I can have the users manually initiate and
authenticate to, but I'd like to keep this as easy for everyone as
possible (except for me, it seems). I suspect I may be able to script
the VPN connection, open the XLS file and then continue to monitor the
open state of the XLS file then then terminate the VPN, but that seems
awfully complex...
Oh, and of course, I'm a network guy who's been tasked with all of
this! I'll gladly trade some Active Directory help for some Excel
help!!!
Thanks, any ideas/thoughts would be greatly appreciated.
I've been tasked with automating a spreadsheet for the boss that needs
to pull SQL data from one of our DB servers, and then format and
import into Excel. The mechanics of doing so aren't the problem.
I want to know how I can securely do this over the web. We'll have
multiple users of this sheet all over the country, and ideally they
would:
1) open the .XLS file
2) press the button I've got a macro tied to
3) the macro goes out and runs the SQL query, and dumps the data into
the sheet
The problem is, the macro contains a credential set for a SQL account,
and while the VB code is password protected in the sheet, the sets
will be traversing the web, open for anyone who cares to look for it.
We've an SSL VPN I can have the users manually initiate and
authenticate to, but I'd like to keep this as easy for everyone as
possible (except for me, it seems). I suspect I may be able to script
the VPN connection, open the XLS file and then continue to monitor the
open state of the XLS file then then terminate the VPN, but that seems
awfully complex...
Oh, and of course, I'm a network guy who's been tasked with all of
this! I'll gladly trade some Active Directory help for some Excel
help!!!
Thanks, any ideas/thoughts would be greatly appreciated.