Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
chris_wood99
Yak Posting Veteran
70 Posts |
 Posted - 2006-03-15 : 10:20:56
|
| Those Pesky management people have asked for the Excel file produced by an automatic data subscription, that gets distributed on email to be password protected. Does anybody know if/how i can achieve this? |
|
|
jhermiz
3564 Posts |
Posted - 2006-03-15 : 13:14:05
|
quote:
Originally posted by chris_wood99
Those Pesky management people have asked for the Excel file produced by an automatic data subscription, that gets distributed on email to be password protected. Does anybody know if/how i can achieve this?
Tell your pesky mgmt team easier said then done.You can not do this directly in RS, in fact this would become a lot more difficult because you'd have to write a macro within excel to initiate this. The problem is you'd need a global xls module that did an on open event and checked if it was a "subscribed" version of the excel file. If it was you would initiate that on open event and protect the sheet. Protecting the sheet via VBA is very simple using the excel object model. But the problem lies in "Tagging" the excel file so you know its just the subscription type excel file and not just any file.A possible solution for you could be that the file gets stored to a network share WHERE only those managers have access to it. How does that sound ?
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]RS Blog -- [url]http://weblogs.sqlteam.com/jhermiz[/url] |
 |
|
|
|
|
|
Automatic Data subscription