-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
pipe delimited
-
A
Macro to export pipe seperated data ( Skip rows )
Can anyone help me adjust my macro. I just need it so that any rows with Value 'Q' in Column A are skipped and not exported to the pipe seperated sheet ? Thanks. Alex Public Sub CharacterSV() Const DELIMITER As String = "|" Dim myRecord As Range Dim myField As...- alex0182828
- Thread
- delimiter macros pipe pipe delimited vba
- Replies: 3
- Forum: Excel Questions
-
M
Pipe-delimited Text File Format
Hi, I am using the below code to Generate a text File in pipe Delimited format. Sub ExportTxt() Dim UsedRows As Long Dim UsedColumns As Long Dim R As Long, C As Long '// Define a suitable file name Open "E:\Folder\" & "TD.txt" For Output As #1 With ActiveSheet...- mamun_ges
- Thread
- pipe delimited text
- Replies: 19
- Forum: Excel Questions
-
J
VBA Help creating a .txt file - Issue with 0's and decimals
Hello, I recently created a macro to create a pipe delimited file from a large spreadsheet. The system that processes the .txt file cannot handle 0's in any cells, but it can handle it if there are decimals (i.e. 0.0). Changing the format of the amounts in the spreadsheet to have decimals...- jakerogers77
- Thread
- dim file macro pipe delimited vba
- Replies: 1
- Forum: Excel Questions
-
F
Pipe Delimited file in VBA Code - Do I have to mess with the Control Panel each time ?
I have a VBA Macro that creates 50 or so CSV files (comma delimited) for our different customers. Here is a simple line I use in the Macro: ThisWorkbook.SaveAs Filename:=SaveToDirectory & “\filename nn.csv”, FileFormat:=6 Now I have one customer who wants a Pipe Delimited file. Is there a...- flynavy
- Thread
- control panel delimited panel pipe delimited vba
- Replies: 1
- Forum: Excel Questions
