User authentication from Excel macro

Posted on 2012-08-15
Last Modified: 2012-09-12
Where I work we have an authentication system where the use types their ID and password before logging into a site.  It's based on the OAuth 2.0 protocol.
I have an Excel macro which needs to use this authentication.  When the user starts the macro it needs to go to this system where they type their ID and password.  If both are correct the macro continues running.
To do this I need to supply an application name.  Once I do this the administrators will give me a unique token.  "Microsoft Excel" won't be acceptable application name as it won't uniquely indentify the macro.
Question by:AlHal2
    LVL 12

    Accepted Solution

    If all you need is a unique application identifier, what about appending the current time/date, either raw or converted into a numeric code, such as 081520120429. "Microsoft Excel 081520120429" should be a unique enough identifier if you don't have hundreds of users constantly using this interface.

    Author Comment

    I don't think the system administrators would accept such an application name.  What they have in mind is a website.

    Author Comment

    I should have clarified my question.  How do I get a vba macro to go to a website where the user can enter their ID and password.
    Once the system has confirmed the ID and password are correct the macro should carry on running.
    LVL 44

    Expert Comment

    by:Martin Liss
    This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    6 Surprising Benefits of Threat Intelligence

    All sorts of threat intelligence is available on the web. Intelligence you can learn from, and use to anticipate and prepare for future attacks.

    Suggested Solutions

    Title # Comments Views Activity
    MsgBox 2 28
    Select a random value from list and chg background color. 5 21
    VBA filters 2 21
    Match Values and Return to Cell 6 14
    When designing a form there are several BorderStyles to choose from, all of which can be classified as either 'Fixed' or 'Sizable' and I'd guess that 'Fixed Single' or one of the other fixed types is the most popular choice. I assume it's the most p…
    Article by: Martin
    Here are a few simple, working, games that you can use as-is or as the basis for your own games. Tic-Tac-Toe This is one of the simplest of all games.   The game allows for a choice of who goes first and keeps track of the number of wins for…
    This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
    Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now