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?

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top