+ Reply to Thread
Results 1 to 2 of 2

Export to CSV writes extra 130 lines of commas

  1. #1
    Forum Contributor
    Join Date
    06-23-2014
    Location
    Dubbo, Australia
    MS-Off Ver
    EXCEL 2019
    Posts
    180

    Export to CSV writes extra 130 lines of commas

    Hi all,

    I have some VBA code behind a command button that exports the rows and columns in a worksheet called "Temp". For some reason I cannot understand, it is also writing 130 lines of ",,,,,,,,," under the last line of real data!
    Can someone take a look at my code and see if it contributes to this, or whether I should look into the "temp" sheet contents further?
    Everything works perfectly EXCEPT for the addition of the extra 130 lines of commas...

    Please Login or Register  to view this content.
    Pete
    Struggling Solutions Architect

  2. #2
    Forum Contributor
    Join Date
    06-23-2014
    Location
    Dubbo, Australia
    MS-Off Ver
    EXCEL 2019
    Posts
    180

    Re: Export to CSV writes extra 130 lines of commas

    All fixed folks,

    I was copying the entire contents of sheet "Registrations" to sheet "Temp", then trying to export the contents to the CSV.
    Removing the part of the code to copy from one sheet to another, and just exporting the contents from the original sheet "Registrations" fixed the problem lol

+ 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. Reading in csv file where there are quotes in records and extra commas
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-17-2015, 01:25 PM
  2. [SOLVED] Remote extra commas from Column
    By satputenandkumar0 in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 07-21-2014, 08:54 AM
  3. Convert to CSV , extra commas displaying
    By yashu in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2013, 08:49 PM
  4. Export Selection as MS-DOS CSV File with 12 commas
    By lesoies in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-29-2012, 04:42 AM
  5. Create CSV without extra Commas
    By naveenkharb in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-02-2010, 10:56 AM
  6. how to stop excel from adding extra inverted commas?
    By podcast in forum Excel General
    Replies: 1
    Last Post: 07-27-2007, 06:49 PM
  7. Extra trailing commas in exported CSV
    By lucidr in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2006, 08:40 AM

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