csv output

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

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

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

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

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

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

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

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

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

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

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