+ Reply to Thread
Results 1 to 1 of 1

Web Query to clickable download .csv file

  1. #1
    Registered User
    Join Date
    11-30-2019
    Location
    Portland, OR
    MS-Off Ver
    2019
    Posts
    1

    Web Query to clickable download .csv file

    Hello,

    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.

    Thanks.
    Last edited by gojevs; 12-01-2019 at 02:45 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA Query to Download a CSV file and to import in the sheet
    By sathis in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-04-2015, 11:15 AM
  2. Entering a clickable Explorer File link....
    By yozzdi in forum Excel General
    Replies: 2
    Last Post: 10-16-2014, 07:12 PM
  3. [SOLVED] File Download Name assuming Thread Title as File Name Windows 2007
    By jaslake in forum Suggestions for Improvement
    Replies: 10
    Last Post: 03-19-2014, 01:07 PM
  4. Using web query to download data from multiple urls.
    By jackuspi2010 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-27-2013, 07:04 AM
  5. [SOLVED] Web query to download web page data to excel in text format
    By panditji in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-15-2012, 12:30 AM
  6. Clickable link to file in CDO Email body
    By cschoyer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2012, 02:11 PM
  7. [SOLVED] Can I download Microsoft Query? Missing software for my Version.
    By Tracie in forum Excel General
    Replies: 1
    Last Post: 01-09-2005, 01:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1