Get eID info and put it in Excel

[Luc Wijns]

Rode Kruis Vlaanderen is using some Excel files to collect eID info. This are still using SDK 3,5 based VBA but the used libraries are no longer supported from version 4,1. For the time being, we still use Excel 2003 for reasons of compatibility with other software that will be replaced within a year or two. We cannot wait for the new software to replace the eID functionality - i.e. about 2 years - as this software is used for disaster management purposes. What can we do to upgrade to eID software 4,1 within Excel 2003. Note that I only have notions of Excel VBA but I am not a full blown programmer.

Kind regards,

Luc

[Frederik Vernelen]

Hello Luc,

We have a C# wrapper (pkcs11net) for our pkcs11 SDK (which is SDK 4.x).
You can find this C# wrapper here:
https://github.com/Fedict/eid-mw/tree/master/doc/sdk/wrappers/C%23%20pkcs11wrappers/pkcs11net

This C# wrapper can probably be imported into a VBA project, but we did not try this ourselves.

Some info about this can be found here: http://stackoverflow.com/questions/21891232/how-to-use-c-sharp-class-in-excel-vba

Another approach could be to use the drag and drop feature of our eID Viewer:

You can drag the picture that is shown in the eID Viewer onto the desktop and save the content of the eID Card into an xml file, which you can use later to import it into your excel file.

Or you might be able to use drag and drop of your VBA project to parse the dragged content. (I have no experience with VBA, but a quick search on the net shows it might be possible:
http://stackoverflow.com/questions/20569959/vba-drag-and-drop-file-to-user-form-to-get-filename-and-path)

Some more info about the eID Viewer's drag and drop feature can be found here:
https://github.com/Fedict/eid-viewer/tree/master/xml

Wkr,

 Frederik

--
You received this message because you are subscribed to the Google Groups "eID Middleware Dev" group.
To unsubscribe from this group and stop receiving emails from it, send an email to eid-middleware-dev+unsub...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.