csv output

  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. H

    Worksheet save as .csv(Comma deli) and rename as .txt by cmd.exe

    I am trying to save a sheet as .Csv (Comma delimited) and then rename as .Txt by Cmd.exe (Shell) but not working. Please help me !!! Dim MyFolder As String, MyFile As String, MySheetName as String Dim ShellComand As String ......... MyFolder = "D:\Revise" MyFile = Dir(MyFolder & "\*.txt")...
  3. G

    Save as CSV (modifying SAVE.AS)

    I have the following formula. It works for saving as a new workbook. How can I get it to work for saving as CSV? I have tried adding ".csv", FileFormat:=xlCSV to it but no such luck thus far. Cheers :) ActiveWorkbook.SaveAs Filename:="C:\User\Test.CSV" & Test1Str & " " & TestStr & " "...
  4. T

    Export visible cells in a range as a csv

    Hi Mr. Excel geniuses, Thanks for taking the time to help. I wrote a function (copied down below) a while ago to export a range as a csv and now I want to modify it. Because I'm filtering a list and I only want the items that are filtered to be exported, I need it to do the same thing except I...
  5. V

    Excel To Csv

    I Have 3 column and 5 row data. Can anyone please help me how to write a code that on click of a button it convert excel into csv by promting save location. Note: Columns are fixed but rows can be increased and decreased. Thanks in advance
  6. X

    VBA code and data concatenation

    Hello I wonder that someone can help me? I have a folder with several photos (jpg and png) whose names are numbers and letters eg 12345.jpg 12345a.jpg 12345b.jpg 12345c.png 9876.png 9876a.png 9876b.jpg etc. and I was wondering how to make an application in vba to list all the photos names in...
  7. C

    converting csv date/time fields to excel

    Good day everyone. My first post! I've downloaded a csv file from my companies ticketing system and need some help to make use of the data that is contained within it. I'd like to separate the date and the time into different fields. I've tried using the "left(text,[num_char]) function, but is...
  8. C

    Macro to copy all worksheets into CSV files

    Hi Excel Masters, I am writing a new thread to make sure this is clear. As i am useless in VBA, I am hoping that someone will write or copy an existing code to do the following : - Save all worksheets of the current workbook into CSV files under the name of each worksheets - the cherry on top...
  9. DougDR

    Saving to CSV

    <!--[if gte mso 9]><xml> <w:WordDocument> <w:View>Normal</w:View> <w:Zoom>0</w:Zoom> <w:PunctuationKerning/> <w:ValidateAgainstSchemas/> <w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid> <w:IgnoreMixedContent>false</w:IgnoreMixedContent>...
  10. N

    Create a csv with quotes

    I need to create a csv text file with the fields acutally delimited by commas and with quotes around each field. I am starting from an excel file and saving the file as a csv. But this approach leaves me with out the quotes. So if I start with this in an excel csv <TABLE style="WIDTH: 303pt...
  11. M

    Convert single PO line item to multiple rows based on quantity ordered

    Hi. I'm trying to build a process to aid our warehouse in printing barcode labels for inventory received. Currently someone has to take the PO/receiving document and manually enter the part number into a text file on a separate row for each individual piece that is received so our barcode...

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
Top