Protecting excell file...

[deef]

I wish to place a version number on my webserver in a simple txt file or other file:
mywebservercom(cannotplacelinkshere)/version.txt

The txt files is only this:
Version 1.1

So everyone can read the text file when you go to the right url.

Now I wish to do something with excell, to check compare the version number from the hosting with the intern version number in the excell file.

So when the user has a old excell version, it won't work anymore.

Can someone point me in the right direction for this ?

Cheers,

Deef

[Kenneth Hobs]

We have discussed similar things in the past.
1. You need to make sure that macros are enabled. To do that, you must hide all but one sheet at close and then unhide all if the criterion is met on Open.
2. Download the file and open to read the value for the criterion part.
a. Compare value to a cell or better yet, a file property value.
3. Protect the vba project.
4. Expect that your code could be cracked.

Of course if Internet is not available and the current file is not downloaded, they would not be able to open the workbook.

We have done both parts 1 and 2 in this forum. I won't have time to see if others post a solution or links to those solutions until Sunday.