User authentication from Excel macro

Posted on 2012-08-15
Medium Priority
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
  • 2
LVL 12

Accepted Solution

telyni19 earned 2000 total points
ID: 38298344
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

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

Author Comment

ID: 38299639
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 50

Expert Comment

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

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When you see single cell contains number and text, and you have to get any date out of it seems like cracking our heads.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

839 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