M
Mats Samson
I’m always ending up messing around with the digital certificates!
I’ve developed an Order & Invoice System in Excel VBA for our small company.
There are 5 files with userforms and plenty of code including a emailed
routing file that is used to update the “databases†with new documents. All 4
users have their own copy.
As far as I found, the digital certificate I issue for our System may never
be accepted by any of the others. Whether I give them my trusted certificate
as a file and manually install it on their computers as trusted, it still
cannot be used as a “general†certificate for our system! They have to use
their own self-cert certificates.
Furthermore, any self made certificate is even on user-account basis only
not on computer basis as it’s written in Excel Help.
If I change the user account in the computer, I have to issue a new
certificate for the new user and recertify the Excel files with it. This is
what recently happened when we made changes to the server. Making new user
accounts in the workstations have forced us to make new certificates and
recertify every file on every computer with the new user based certificate.
We plan to do some more changes so now I wonder, do we have to go through
this tedious process once again?
Can anybody explain how we may have our own copies of the System and from
time to time receive updated files without recertifying the file(s) with a
user based certificate?
I’ve developed an Order & Invoice System in Excel VBA for our small company.
There are 5 files with userforms and plenty of code including a emailed
routing file that is used to update the “databases†with new documents. All 4
users have their own copy.
As far as I found, the digital certificate I issue for our System may never
be accepted by any of the others. Whether I give them my trusted certificate
as a file and manually install it on their computers as trusted, it still
cannot be used as a “general†certificate for our system! They have to use
their own self-cert certificates.
Furthermore, any self made certificate is even on user-account basis only
not on computer basis as it’s written in Excel Help.
If I change the user account in the computer, I have to issue a new
certificate for the new user and recertify the Excel files with it. This is
what recently happened when we made changes to the server. Making new user
accounts in the workstations have forced us to make new certificates and
recertify every file on every computer with the new user based certificate.
We plan to do some more changes so now I wonder, do we have to go through
this tedious process once again?
Can anybody explain how we may have our own copies of the System and from
time to time receive updated files without recertifying the file(s) with a
user based certificate?