Office Data
Office Data
(OP)
Hello all,
How can I save data in MS Office applications using VBA. Now I realise how stupid this sounds at first glance, so let me elaborate....
I want to store essentially hidden data so that users are unaware of it an therefore cannot fiddle.
MS Word has the ability to use variables (http://support.microsoft.com/kb/306281) but that is no good for Excel, Access or PowerPoint.
I cannot use registry entries as then do not follow the documents when they are copied and used by individuals.
Is there a way to achieve this?
Thanks
How can I save data in MS Office applications using VBA. Now I realise how stupid this sounds at first glance, so let me elaborate....
I want to store essentially hidden data so that users are unaware of it an therefore cannot fiddle.
MS Word has the ability to use variables (http://support.microsoft.com/kb/306281) but that is no good for Excel, Access or PowerPoint.
I cannot use registry entries as then do not follow the documents when they are copied and used by individuals.
Is there a way to achieve this?
Thanks
RE: Office Data
TTFN
FAQ731-376: Eng-Tips.com Forum Policies
RE: Office Data
If you just want to avoid casual tampering you can write the data to a hidden and password protected worksheet in Excel using VBA.
That won't stop someone determined to get at the data, but if it is that sensitive you need to be using something other than Office.
For Access and Powerpoint I don't know, but at least in Access I'm sure there are ways to protect data, which would probably be more secure than Excel.
Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/
RE: Office Data
You might also change the excel workbook to an add-in and password protect it. As an add-in your functions would run in the background and all the worksheets in the add-in workbook would be inaccesable to users. This should protect both the VBA code and any information stored in the worksheets.
Like IRstuff said, depends on how much data you want to store and how sensitive it is.
-JTBorton
Well, You can try banging your head against the wall, but you just end up with lost-time injuries and damaged equipment. [M. Passman]
RE: Office Data
TTFN
FAQ731-376: Eng-Tips.com Forum Policies