+ Reply to Thread
Results 1 to 4 of 4

csv table download from URL wit sporadic problem with comma delimiter

  1. #1
    Registered User
    Join Date
    11-26-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    11

    csv table download from URL wit sporadic problem with comma delimiter

    Hi
    I have been trying to automate a csv table download into excel from a url (US Treasury) which works when done manually and was working for a while using the below VBA. Now however, it has decided that it doesn't want to recognise the comma delimiter and is dumping everything into just the one column. The code and url are included below and I would very much appreciate anyone who might point out where I may have erred, as I'm currently flummoxed on what I original thought was a relatively simple script!
    Please Login or Register  to view this content.
    Last edited by Paul; 02-24-2022 at 07:04 PM. Reason: Added CODE tags

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux - O365
    Posts
    12,694

    Re: csv table download from URL wit sporadic problem with comma delimiter

    Hi
    are you still using XL2010 ? If not please amend your profile accordingly.
    This being said, wouldn't it be easier to achieve using Power Query ? I can't help for the moment, but it's worth looking into.

  3. #3
    Forum Guru
    Join Date
    03-28-2012
    Location
    TBA
    MS-Off Ver
    Office 365
    Posts
    12,445

    Re: csv table download from URL wit sporadic problem with comma delimiter

    Since the URL is being fetched from a cell, we can't see it. Attach the sample with the code.

  4. #4
    Registered User
    Join Date
    11-26-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    11

    Re: csv table download from URL wit sporadic problem with comma delimiter

    I think I have identified the underlying problem, but not the solution.
    The problem seems to be that the output cell is on A2, so that I can include formulas on row 1 to reformat the header on the downloaded csv table. If I do not populate Row 1, then the script works ok in both downloading and sorting to csv table. However, when I include the formulas on Row 1, that is when I get the error.

+ 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] Split a column using comma delimiter
    By brent_milne in forum Excel General
    Replies: 5
    Last Post: 10-09-2019, 01:45 PM
  2. .txt files (delimiter: comma) into .xls or .xlsx file
    By Pradeep M B in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-01-2013, 09:57 AM
  3. [SOLVED] Semicolon Delimiter instead of comma ?
    By atomicsp in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 01-01-2013, 10:40 PM
  4. Prevent Comma delimiter on txt file open?
    By mike216 in forum Excel General
    Replies: 15
    Last Post: 03-27-2012, 11:41 AM
  5. Comma delimiter
    By Jon Quixley in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-25-2006, 11:50 AM
  6. Change delimiter in import function from comma to tab
    By marksince1984 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-13-2006, 12:40 AM
  7. Comma delimiter for csv downloads?
    By Les M in forum Excel General
    Replies: 7
    Last Post: 01-30-2006, 09:10 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