VBA Read File Write File Code Question

[jasonneuman]

How do you Read a file in and Write a file out in a Comma Delimited format. I realize this is probably basic stuff but I am really new to VBA.

Example I have a (file named F30001x30.txt) and I want to produced the comma delimited format into a (file named F30001q30.txt)

Any help would be greatly appreciated.

Jason Neuman

 

[xlbo]

Just record yourself opening the file into excel and then saving it as .csv
HTH
Geoff

 

[ratman]

Via Excel:

ChDir "C:\"
Workbooks.OpenText FileName:="C:\F30001x30.txt", Origin:=xlWindows, _
StartRow:=1, DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, _
ConsecutiveDelimiter:=False, Tab:=False, Semicolon:=False, Comma:=True _
, Space:=False, Other:=False, FieldInfo:=Array(Array(1, 1), Array(2, 1), _
Array(3, 1), Array(4, 1))
ActiveWorkbook.SaveAs FileName:="C:\F30001q30.csv", FileFormat:=xlCSV, _
CreateBackup:=False

 

[xlbo]

Just a note to say that this will work for the main part but the
FieldInfo:=Array(Array(1, 1), Array(2, 1), _
Array(3, 1), Array(4, 1))
line will change dependant on number of fields - that's the problem with opening .txt files, the array is different every time which is why you need to record it on the text file you will be using
HTH
Geoff

 

[jasonneuman]

How do you Read a file in and Write a file out in a Comma Delimited format. I realize this is probably basic stuff but I am really new to VB.

Example I have a (file named F30001x30.txt) and I want to produced the comma delimited format into a (file named F30001q30.txt)

Any help would be greatly appreciated.


I realize I asked for VBA on the other post but I meant to put VB. Thank you for the previous help

 

[xlbo]

Maybe you should post this question in the VB forum then
Do a serarch on forums for "VB" and about 6 or 7 come up - would've thought they'd know in there
HTH
Geoff