csv file format

  1. D

    Macro to save a CSV with a tilde as delimiter

    Gentlemen, Using a VBA macro, is there a way to save a CSV file a tilde delimiter instead of comma? Thank you
  2. K

    VBA Exporting SubReports as CSV files from a sheet

    First of all, I will be very grateful if someone could help with this. I have a long report on a sheet with over 1000 subreports. It looks like this: columns A,B,C,D Name,Target1,Target2,Target3 SubReport1,1,0,0 SubReport1,1,1,6 SubReport2,1,0,0 SubReport2,1,0,0 SubReport2,1,2,6...
  3. T

    save scv file as xlsx

    I want to write a macro that will save the current filename.csv file as filename.xlsx How to do it?
  4. B

    excel save as csv with quotes around specific columns

    Hi, I have an excel file, that I want to save as csv, but I cannot save with quotes around some columns, so I found 2 codes to add quotes but it will apply it around all the column this is the first code Sub CSVFile() Dim SrcRg As Range Dim CurrRow As Range Dim CurrCell As Range Dim...
  5. F

    text to columns - delimited

    Hi, I have csv file. Normally in excel I select column "A" and can do -> text to column -> delimited >semicolon and everything will be done ok. I need to do it exaclty this same but in VBa. sub TEST Dim FileToOpen, sourceFile, outputFile As String Dim TextLine() As Integer Dim sourceWb As...
  6. H

    AutoSave Excel in Different format

    Hi, This is my first post to this forum, although I am working on a potential project for my University and was curious if what I need to do is going to be possible. 1] Have Excel document save every second. * Found some people discussing this with code so I know that this is...
  7. F

    Can't retrieve data in CSV format

    Hello, I'm having a problem saving my data in CSV files. I have barcodes that need to be imported into a windows system for a library. However when I save my file in CSV format, all the columns display 3E+11. I've tried to change the column format to "numbers", but it still doesn't do...
  8. S

    How can I save xls as csv w/o getting error 1004

    Here is a portion of my vbs code. In this code I open each xls file in a directory, for each file I simple want to save the file as a csv. When the saveas method execute I receive an error 1004 and the following message. "1004 Microsoft Excel SaveAs method of Workbook class failed" Anyone...
  9. O

    CURE: Export more than 65000 lines access to excel

    Hi Guys, I thought I'd post a reminder of the cure to this problem. In case someone else searches for it. It was the bane of my existence yesterday. If your query or table has more that 65000 you can only export it without formatting. And you may have to create a new file name (it doesn't...
  10. jeffcrtra

    Open CSV files with variable name

    Hey folks, greetings! I have been dealing with this issue for a while already. Because of my work I must create files and save them with variable name (date of creation), the format should be CSV. I made a macro that makes all the work for me, taking the name from a specific cell and saving...
  11. D

    CSV files - conflict with DDE?

    When our company upgraded to Office 2007 last year, we had considerable problems with Excel in opening XLS and XLSX files. We had to either disable DDE in the file association properties, and/or add the "%1" notation after the opening string in file association. We've had just occasional...
  12. N

    Opening csv file with macro causes date format to change

    Hi, I'm using some code I found on this forum to open a csv file. One of the columns contains dates and when opening the file using the macro the date format is changed from dd/mm/yyyy to mm/dd/yyyy but only if the date is on or before the 12th month. If the file is opened manually the date...
  13. H

    Opening a CSV file

    When I open a CSV file in Excel, all of the data is being placed in to one cell, with quotation marks around each value. What settings do I need to change to have the file open correctly?

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back