credentials

All, I am trying to fetch the live stocks data from NSE website and I have used the Data -> "From Web" function for the same. Below are the attributes which I have fetched from the site: Source =...

I am running into an issue when using the Query Table Connection. I am trying to access a URL that provides a data set that I want to import into Excel. When the macro access the server, it prompts the user to enter their password. Is there any code available to hard code the username/password...

Hello! I am new to this forum, and also new to VBA. I am doing a daily report, that is supposed to send automatically every day as pdf to the managers in my company. The report consists of pivot tables and charts, that mainly use an external data source (SQL database). I created the pivot...

Hey all, I have been able to map a network drive of a sharepoint site after I logged into it successfully. I want to make it as painless as possible for other people however. I am using smart card credentials to access the sharepoint so the username and password functions do not work in this...

Hello I have an Excel 2010 file with a macro built into it to refresh several tables drawing from an outside source (AS400/PRMS specifically). The file is set up in a such a way that the tables are condensed & combined into an easily readable report. The report will be used by several...

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