LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #18   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3,514
Default ThisWorkbook.Close()

"GS" wrote:

Note: If file encryption isn't doable for you then at very least
set the file's 'Hidden' attribute so it doesn't appear in file
browsers.

The utility is proprietary to my user and so if you're interested
in getting more into this I'm willing to do so offline via email if
you provide yours in a followup reply. Proprietary means each
release of the utility uses its own (unique) 256 bit encryption key
to ensure other users can't work with the file's contents, and the
location of the uap.dat file is hard-coded to a user-specified
path.


Hey Gary, thanks for offering the details of your proprietary
utility,
but I don't think it will be necessary.


You're welcome! Turns out, though, that that utility as a VB6exe is
under construction anyway due to changing the UI format of my Excel
version. I plan to finish it up so it's a 'done' item on my todo list.

I will be the only user who has control of our authorized user file.
Nobody else will know of its existence or location. It is just a
simple text file that I will edit with Notepad, and it will be stored
down a long path of sub-folders, possibly with a hidden file
attribute as well. Now I just need to work on the text file reader,
and I think you already put me in the right direction. Thank you!

Robert


Sounds good to me, Robert! Let me know if you want/need help with
coding for file encryption...

EncryptStringToFile
DecrpytFileToString

...are as simple to use as the read/write procedures, but they require
their Class wrapper be added to your project!<g

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
ThisWorkbook.Close crashing Excel (2010) Clif McIrvin[_4_] Excel Programming 11 October 19th 10 01:58 AM
ThisWorkbook.Close question Robert Crandal Excel Programming 2 January 24th 10 01:38 PM
Application.StatusBar not refreshing after ThisWorkbook.Close LEO@KCC Excel Programming 6 September 12th 07 10:41 AM
ThisWorkbook.close doesn't wokk :( Arnaud.L Excel Programming 9 April 1st 04 08:46 AM


All times are GMT +1. The time now is 12:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"