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

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top