+ Reply to Thread
Results 1 to 3 of 3

Possibility of calling external Fingerprint program

  1. #1
    Registered User
    Join Date
    04-01-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    8

    Possibility of calling external Fingerprint program

    Hi, I'm working with several freelancers to develop a simple excel based inventory system with fingerprint authentication.The general workflow of this app is :

    1. Assuming there are 3 shifts per day, A, B, C

    2. Employee A inputs data for Shift A in Sheet A

    3. When changing shifts from Shift A to Shift B, excel calls fingerprint app, and authenticate employee A and B's fingerprints.

    4. Once the prints are accepted. Sheet A will be locked, and Employee B continue with Sheet B for Shift B for inputting data.

    5. And same procedure for Shift B to Shift C to Shift A and so on

    We are using excel to simplify the project and it's already installed on users machine..

    But before moving forward,we are trying to figure out whether it is possible or not for excel to call fingerprint app using Digital Persona's SDK,and also accept and send input from the app.The SDK documentations says it supports .NET ActiveX,On the documents, these are all i could find related to activeX

    //i.imgur.com/9GUOWv8.jpg

    //i.imgur.com/FJR8w5R.jpg

    Here's the rest of the documentations for complete reference

    //drive.google.com/file/d/1QDK02hD-80yPIs_6tvfIuIBZBDkTwU8m/view

    >can't post links yet

    I'm just wondering whether this is possible or not before we decide to use excel as the platform.

    thanks
    Last edited by denywinarto; 08-07-2019 at 09:19 AM.

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,805

    Re: Possibility of calling external Fingerprint program

    Will you please attach a small sample Excel workbook? We are not able to work with or manipulate a picture of one and nobody wants to have to recreate your data from scratch.

    Unfortunately the attachment icon doesn't work at the moment (it hasn't worked for years, and despite our repeatedly asking the technical team who own the forum to fix it, they can't be bothered to do so), so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

    Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    04-01-2013
    Location
    Indonesia
    MS-Off Ver
    Excel 2003
    Posts
    8

    Re: Possibility of calling external Fingerprint program

    Well, the workbook is not in english, and the content has little to do with what i'm trying to figure out.
    But for the sake of simpler explanation, i've attached a simpler version of my workbook.

    Ignore the top tables, and focus on the "CHANGE SHIFT TO SHIFT X" buttons
    What i want to ask is,

    With excel VBA, would it be possible with those buttons to do this procedure,
    Let's use Shift A to Shift B as example :

    1. When the button is pressed, Call fingerprint app,
    2. Authenticate fingerprints of Shift A and B's employees
    3. Once the prints are correct and accepted, lock Shift A
    4. And the same thing for Shift B to Shift C

    So to clarify again, i'm not asking to develop the fingerprint apps, or the inventory apps,
    I'm simply asking whether this action is possible or not in VBA programming,
    based on the Fingerprint SDK documentation i gave on the first post.

    I know little of VBA programming, but my colleagues told me it's utilizing activeX,
    and activeX is listed on the SDK documentations.
    From here on we could decide whether we can use excel or do we have to use another platform.
    Attached Files Attached Files
    Last edited by AliGW; 08-08-2019 at 05:25 AM. Reason: Please don't quote unnecessarily!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Excel calling external Dll
    By PaulLag in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-15-2016, 06:03 PM
  2. Calling a sub-program
    By cdesantis01 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-27-2014, 06:12 AM
  3. [SOLVED] help with calling a function (B) and return control of program flow to the calling functio
    By john/nyc in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 10-26-2012, 11:06 AM
  4. Calling Cell Range within Loop Program
    By smlaff01 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 11-15-2007, 05:59 PM
  5. [SOLVED] Calling a Program
    By Bill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2006, 05:00 PM
  6. [SOLVED] calling excell from an external program
    By עומר in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-11-2005, 09:05 PM
  7. Program calling up Excel - Not running Macro
    By kraljb in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-28-2005, 02:05 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1