Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Password Protected EXL Template

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[CLOSED] Password Protected EXL Template
 Login/Join
 
saggy
Gold member
posted
i have requirement where i need to send an EXL output which needs to be a password protected.Can this functionality be achieved through a EXL Template??.Because WF version 7.6.8 doesn't have this functionality.

This message has been edited. Last edited by: Kerry,


7.6.4
Unix & Windows
Excel,HTML,PDF,PPT,AHTML


 
Posts: 68 | Location: Hyderabad | Registered: March 18, 2008Report This Post
<JG>
posted
Even if your version of WebFOCUS did allow protection it's not complete.

It does not support a password and can be turned off by the user simply by clicking the option in excel.

I was sure this had been posted before but cannot find the link

 
Sub Workbook_Open() 

 ActiveSheet.Protect Password:="xxxxxxxx", DrawingObjects:=True, Contents:=True, Scenarios:=True 

End Sub


Make sure that you protect the macro in the VBA editor otherwise they will get the password simply by reading it.

If I remember the post I cannot find, Tony A suggested using the Random number generator to assign the password.

Only disadvantage is you will not know it either.

This message has been edited. Last edited by: <JG>,
 
Report This Post
Tony A
Expert
posted Hide Post
I can't find it either Frowner

Saggy,

What is the underlying requirement?

If it is so that they can manipulate the data for "what-if" scenarios, but not save any changes then you can code in VBA for that.

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
saggy
Gold member
posted Hide Post
Hi tony,
The Requirement of the report is actually a report caster job distributing an excel output to some users thru email.And whn the users try to open the password the excel shld prompt for a password.and even if they save this attachement to their hard drive if any one unknowingly opens it , it shlould prompt for a password.so this is how the security to that excel has to be provided.


7.6.4
Unix & Windows
Excel,HTML,PDF,PPT,AHTML


 
Posts: 68 | Location: Hyderabad | Registered: March 18, 2008Report This Post
Tony A
Expert
posted Hide Post
Time to dig out your VBA manuals .......

T


In FOCUS
since 1986		WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2  
WebFOCUS App Studio 8.2.06 standalone on Windows 10 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Steve
Member
posted Hide Post
We have a similar requirement. Unfortunately, any time I use VBA macros, the customer is prompted with a "would you like to allow macros" message any time they open the document. So...... all he/she has to do is click "No" and then I no longer have password protected Excel documents.


WebFOCUS 7.7.02 Teradata, Oracle
Windows
Outputs: HTML / PDF / Excel
 
Posts: 13 | Location: Michigan | Registered: December 09, 2008Report This Post
saggy
Gold member
posted Hide Post
steve can u send me code to implement the fucntionality and also could u provide the example of using the so created excel template.


7.6.4
Unix & Windows
Excel,HTML,PDF,PPT,AHTML


 
Posts: 68 | Location: Hyderabad | Registered: March 18, 2008Report This Post
DeepakD
Member
posted Hide Post
Hi Friends,

Do we have this as a new feature in current webfocus version? I have got similar requirements, exploring ways to achieve this.


Regards,

Deepak
WebFOCUS 7.6.11
Redhat Linux 5.5
Excel, pdf, HTML
 
Posts: 13 | Registered: July 14, 2008Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [CLOSED] Password Protected EXL Template

Copyright © 1996-2020 Information Builders