authentication

NOTE: I'm not a sysadmin user so apologies if I am using terms like authentication in correctly. DESC: When I have Chrome open and connected to a cloud based application which works with Office365 Pass thru Authentication, if I click on a hyperlink (that is to a web page within that cloud...

Hey Guys, I have some 200 excel workbooks with password protected. Whenever i/my team wanna open this workbook need to be given the password, Is it possible to give some windows/User authentication for those specific excel sheet to bypass the password protection ? Dinesh S

Hi, i am experimenting with the following: Sub testXMLHTTP_VBA()Dim xmlhttp As Object, myurl As String Set xmlhttp = CreateObject("MSXML2.serverXMLHTTP") myurl = "https://www.mrexcel.com/forum/excel-questions/" xmlhttp.Open "GET", myurl, False xmlhttp.Send MsgBox (xmlhttp.responseText) End...

I am working on a excel macro that selects certain data from workbook and post it to a web service. For that I have to verify the users credentials with sso authentication of our companies main web application. Is there a way to do SSO authentication directly from the macro with excel vba...

Hello all, Is it possible to connect to Oracle server with VBA when the excel application and Oracle resides in different servers? I should mention the server where the oracle resides needs it own authentication. So I need to use a kind of connection to the server with supporting authentication...

I'd like to protect a small area in the excel sheet. Example H45:M47 where the user should put his/her windows username and password as authentication method through a VBA userform window. I'm not a VBA expert due to that fact the full step by step VBA code and setup will appreciate! Thanks

I am trying to utilize <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style: dotted; border-bottom-color: rgb(0, 0, 0); cursor: help; color: rgb(51, 51, 51); background-color: rgb(250, 250, 250);">VBA</acronym> to access a device on a local network...

Hi all, I have been tasked with creating an excel macro that will import xml files into a spreadsheet from an active directory network share. I have the code to import the files, however, if the user running the macro does not have access to the share it throws an error. Is there a way to do...

Hello I am using MS Query to return results in my excel file from an ODBC source which only a specific group of people have access to. Whenever the query is refreshed the user credentials are requested. I had our IT dept. create a default log on for the system the query is pulling from but...

Hi All, I am writing a program which downloads an excel document from a website. This website is protected with "basic access authentication", so I would like to know how to do this. I have already got to the stage of using a webbrowser userform control, navigate2 in particular. Thankyou, Any...

I have developed an interactive application that uses web query to send and receive data with a web site (a LAMP stack) protected with basic authentication. On my primary platform, Excel 2004 (Mac), everything works fine. The first web query automatically (i.e., Excel does this, not my code)...