Web Query to clickable download .csv file
my company uses an online CRM platform to track customers and sales that I would like to download into excel through an automated process. Their export function leads to a download link that downloads a .csv file. I've tried copying the link address into the web query form and get the following error:
Details: "Web.Contents failed to get contents from '...' (500): Internal Server Error" *edit I should add, the begining of the url starts with 'blob:htpps\'
When I attempt to connect to the website using the web query form, after an error it will prompt me to attempt to login and give me:
Details: "The credentials provided cannot be used for the Web source. Please update the credential type through a refresh or in the Data Source Settings dialog to continue
Once I enter my login info under the 'Access web content' form using 'basic' credentials I get told the credentials are invalid but I'm positive I've entered them correctly.
Please advise on how to do this better.
Last edited by gojevs; 12-01-2019 at 02:45 AM.
Users Browsing this Thread
There are currently 1 users browsing this thread. (0 members and 1 guests)
By sathis in forum Excel Programming / VBA / Macros
Last Post: 07-04-2015, 11:15 AM
By yozzdi in forum Excel General
Last Post: 10-16-2014, 07:12 PM
By jaslake in forum Suggestions for Improvement
Last Post: 03-19-2014, 01:07 PM
By jackuspi2010 in forum Excel Programming / VBA / Macros
Last Post: 03-27-2013, 07:04 AM
By panditji in forum Excel Programming / VBA / Macros
Last Post: 09-15-2012, 12:30 AM
By cschoyer in forum Excel Programming / VBA / Macros
Last Post: 08-08-2012, 02:11 PM
By Tracie in forum Excel General
Last Post: 01-09-2005, 01:06 PM
Tags for this Thread
Search Engine Friendly URLs by vBSEO 3.6.0 RC 1