1. D

    Windows/User Authentication for Excel Workbook

    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
  2. J

    MSXML2.serverXMLHTTP : Adding Authentication + getting JSON

    Hi, i am experimenting with the following: Sub testXMLHTTP_VBA()Dim xmlhttp As Object, myurl As String Set xmlhttp = CreateObject("MSXML2.serverXMLHTTP") myurl = "" xmlhttp.Open "GET", myurl, False xmlhttp.Send MsgBox (xmlhttp.responseText) End...
  3. A

    SSO Authetication using VBA

    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...
  4. S

    Connect to Oracle from another computer

    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...
  5. T

    Windows user name and password for 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
  6. A

    VBA Website Automated Authenticated Login

    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...
  7. L

    Access files in a network share on a domain and authenticate users if the sub throws an error.

    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...
  8. R

    Entering user credentials automatically

    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...
  9. S

    Excel VBA - Use webbrowser control to navigate to a page with "basic access authentication"

    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...
  10. 4

    web query with basic authentication

    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)...

Some videos you may like

This Week's Hot Topics