Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB Editor Access
G'day there One & All,
At the moment my work is using Windows 2003, although a few forgotten boxes still have XP on them. Office 2003 is universal but I'm not sure what version, nor which service packs are installed for the OS. Regardless of all that, I have a question which may well be stupid, but which I need to ask anyway - stupidity being an attribute which has never stopped me in the past! My employer is a statewide government agency with over 16000 employees. For use of frontline staff it maintains a "forms package" of over 800 standard forms. The vast majority are Word documents, followed by some Excel worksheets, then a few .PDFs and also some URL's to other agency's online forms. By sheer chance I recently found 2 of these Excel worksheets were password protected, but with unsecured VB Projects with users able to view all the code including the "Protect" & "Unprotect" routines with the forms' passwords exposed. I advised the IT section and that was easily fixed. The idea of opening each document and manually checking protection for 800+ docs is not inviting. The IT section's resources are limited and as a bit of an interesting project I commenced writing an Excel application to check both doocument & project protection and store the results in a Worksheet list indicating which were protected and which weren't. My code iterates across the single folder containing all these documents and load worksheets or starts the MS Word application programatically when required. However, I get an error similar to "Program access to VB Editor refused" (I'm using a different computer to write this and don't recall exact wording). This access needs to be set for each document as it's turned off by default. I understand the reasons this is so and appreciate the security issues surrounding such access. Now to the stupid question part: As I only want to check whether the project is protected, is it possible to workaround this access limitation without setting it by hand for each document/workbook? Yes, I re iterate that it's a stupid question. However just because I shouldn't be able to do this doesn't mean that I can't. In this instance I only need to read data, not alter code but I can't really explain that to the application to make it feel happier about me poking about. I think I know the answer already, but thought that more experienced minds than mine might just know otherwise. Thank you See ya Ken McLennan Qld Australia |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Programatic access to VB-editor not trusted | Excel Programming | |||
How to access Visual Basic Editor via VBA? | Excel Programming | |||
Unable to access VBA editor | Excel Discussion (Misc queries) | |||
VB Editor | Excel Programming | |||
Prevent Access To VBA Editor? | Excel Programming |