SQL ExcelSQL Excel

Freeware Excel Add-In - Simplify data retrieval from SQL Server, Oracle, Sybase, MySQL, DB2, Firebird and any other ODBC compliant database

SQL Excel Support
Welcome, Guest
Please Login or Register.    Lost Password?
Re:EXCEL questions (1 viewing) (1) Guest
Please post here about SQL Excel useage within Excel. Excel / VBA type topics should go in there. Thanks.
Go to bottom Post Reply Favoured: 0
TOPIC: Re:EXCEL questions
#277
waltzation (User)
Fresh Boarder
Posts: 1
graphgraph
User Offline Click here to see the profile of this user
EXCEL questions 4 Months ago Karma: 0  
hi, i hoped i won't get flamed by posting here.

i have a question to asked for, you might find it easy but i am a novice in programming.

lets say i have a testpaper in excel which i created for training purposes using Excel 03 VBA.

and as we know that excel 03 vba is very easy to break the "protected-password" in it.is there anyway to have a more secure way so that the questions and the answer in the excel file do not enable the training students to "cheat" using brute force attack ?
 
Report to moderator   Logged Logged  
  The administrator has disabled public write access.
#278
admin (Admin)
Admin
Posts: 175
graph
User Online Now Click here to see the profile of this user
Re:EXCEL questions 4 Months ago Karma: 1  
Hi !

No flaming here !)

Nope all is fine. Not too familiar with this area but one thing you could look into is to scramble vba code.
I took a quick look on the inet and found this http://invisiblebasic.sourceforge.net/
I think it might be what you are looking for. It can scramble (obfuscate is what the correct term is it seems) the code in an excel sheet so it is not easy to read.
Hope that helps out.
Take it easy and have a nice night, Al
 
Report to moderator   Logged Logged  
 
Last Edit: 2008/09/03 16:53 By admin.
  The administrator has disabled public write access.
Go to top Post Reply
Thanks for using the forum SQL Excel Freeware Add-inget the latest posts directly to your desktop

Google Translate

Copyright SQL Excel, 2007-2008 | valid xhtml? | valid CSS? |Microsoft ® and Microsoft Excel ® are registered trademarks of Microsoft Corporation