Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to text file
I want to export data from several cells into the text file and I am
epxeriencing problem with formatting, I can not have line breaks to give me new line for each entry. I have tried to use Chr(10) and Chr(13) but it does not work. What is wrong in code below: ===================================== Sub PrintAttachments() Dim AttachmentsList As String CheckSecurity AttachmentsList = "" Application.ScreenUpdating = False For i = 1 To 10 For j = 3 To 12 If Worksheets(i).Cells(j, 17) < "" Then AttachmentsList = AttachmentsList + Worksheets(i).Cells(j, 17) & Chr(10) End If Next j Next i If AttachmentsList < "" Then AttachmentsList = "List of attachments: " & Chr(10) & Chr(10) & AttachmentsList Open "c:\temp\attachments.txt" For Output As #1 Write #1, AttachmentsList Close #1 End If Application.ScreenUpdating = True End Sub ===================================== Is there any way of printing my results instead of saving them into txt file ? Thanks for help. Tony |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to text file
First you shouldn't use write, instead use print. Write add double quotes to
the data while print doesn't both have the same syntax. Second, write one line at a time. Print will add the carriage return and line feed Open "c:\temp\attachments.txt" For Output As #1 For i = 1 To 10 For j = 3 To 12 If Worksheets(i).Cells(j, 17) < "" Then AttachmentsList = "List of attachments: " & Worksheets(i).Cells(j, 17) Write #1, AttachmentsList End If Next j Next i Close #1 End If "Tony" wrote: I want to export data from several cells into the text file and I am epxeriencing problem with formatting, I can not have line breaks to give me new line for each entry. I have tried to use Chr(10) and Chr(13) but it does not work. What is wrong in code below: ===================================== Sub PrintAttachments() Dim AttachmentsList As String CheckSecurity AttachmentsList = "" Application.ScreenUpdating = False For i = 1 To 10 For j = 3 To 12 If Worksheets(i).Cells(j, 17) < "" Then AttachmentsList = AttachmentsList + Worksheets(i).Cells(j, 17) & Chr(10) End If Next j Next i If AttachmentsList < "" Then AttachmentsList = "List of attachments: " & Chr(10) & Chr(10) & AttachmentsList Open "c:\temp\attachments.txt" For Output As #1 Write #1, AttachmentsList Close #1 End If Application.ScreenUpdating = True End Sub ===================================== Is there any way of printing my results instead of saving them into txt file ? Thanks for help. Tony |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to text file
Hi Joel,
Thank you. Tony "Joel" wrote: First you shouldn't use write, instead use print. Write add double quotes to the data while print doesn't both have the same syntax. Second, write one line at a time. Print will add the carriage return and line feed Open "c:\temp\attachments.txt" For Output As #1 For i = 1 To 10 For j = 3 To 12 If Worksheets(i).Cells(j, 17) < "" Then AttachmentsList = "List of attachments: " & Worksheets(i).Cells(j, 17) Write #1, AttachmentsList End If Next j Next i Close #1 End If "Tony" wrote: I want to export data from several cells into the text file and I am epxeriencing problem with formatting, I can not have line breaks to give me new line for each entry. I have tried to use Chr(10) and Chr(13) but it does not work. What is wrong in code below: ===================================== Sub PrintAttachments() Dim AttachmentsList As String CheckSecurity AttachmentsList = "" Application.ScreenUpdating = False For i = 1 To 10 For j = 3 To 12 If Worksheets(i).Cells(j, 17) < "" Then AttachmentsList = AttachmentsList + Worksheets(i).Cells(j, 17) & Chr(10) End If Next j Next i If AttachmentsList < "" Then AttachmentsList = "List of attachments: " & Chr(10) & Chr(10) & AttachmentsList Open "c:\temp\attachments.txt" For Output As #1 Write #1, AttachmentsList Close #1 End If Application.ScreenUpdating = True End Sub ===================================== Is there any way of printing my results instead of saving them into txt file ? Thanks for help. Tony |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to text file
Hi Joel,
How I can have it without quotation marks ??? Sample output file looks like: ======================= "List of Attachments :" "Attachments 1" "Attachments 2" ======================= Thank you. Tony "Joel" wrote: First you shouldn't use write, instead use print. Write add double quotes to the data while print doesn't both have the same syntax. Second, write one line at a time. Print will add the carriage return and line feed Open "c:\temp\attachments.txt" For Output As #1 For i = 1 To 10 For j = 3 To 12 If Worksheets(i).Cells(j, 17) < "" Then AttachmentsList = "List of attachments: " & Worksheets(i).Cells(j, 17) Write #1, AttachmentsList End If Next j Next i Close #1 End If "Tony" wrote: I want to export data from several cells into the text file and I am epxeriencing problem with formatting, I can not have line breaks to give me new line for each entry. I have tried to use Chr(10) and Chr(13) but it does not work. What is wrong in code below: ===================================== Sub PrintAttachments() Dim AttachmentsList As String CheckSecurity AttachmentsList = "" Application.ScreenUpdating = False For i = 1 To 10 For j = 3 To 12 If Worksheets(i).Cells(j, 17) < "" Then AttachmentsList = AttachmentsList + Worksheets(i).Cells(j, 17) & Chr(10) End If Next j Next i If AttachmentsList < "" Then AttachmentsList = "List of attachments: " & Chr(10) & Chr(10) & AttachmentsList Open "c:\temp\attachments.txt" For Output As #1 Write #1, AttachmentsList Close #1 End If Application.ScreenUpdating = True End Sub ===================================== Is there any way of printing my results instead of saving them into txt file ? Thanks for help. Tony |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel to text file
I have replaced write with print and now I have what I wanted. Thank you.
Tony "Tony" wrote: Hi Joel, How I can have it without quotation marks ??? Sample output file looks like: ======================= "List of Attachments :" "Attachments 1" "Attachments 2" ======================= Thank you. Tony "Joel" wrote: First you shouldn't use write, instead use print. Write add double quotes to the data while print doesn't both have the same syntax. Second, write one line at a time. Print will add the carriage return and line feed Open "c:\temp\attachments.txt" For Output As #1 For i = 1 To 10 For j = 3 To 12 If Worksheets(i).Cells(j, 17) < "" Then AttachmentsList = "List of attachments: " & Worksheets(i).Cells(j, 17) Write #1, AttachmentsList End If Next j Next i Close #1 End If "Tony" wrote: I want to export data from several cells into the text file and I am epxeriencing problem with formatting, I can not have line breaks to give me new line for each entry. I have tried to use Chr(10) and Chr(13) but it does not work. What is wrong in code below: ===================================== Sub PrintAttachments() Dim AttachmentsList As String CheckSecurity AttachmentsList = "" Application.ScreenUpdating = False For i = 1 To 10 For j = 3 To 12 If Worksheets(i).Cells(j, 17) < "" Then AttachmentsList = AttachmentsList + Worksheets(i).Cells(j, 17) & Chr(10) End If Next j Next i If AttachmentsList < "" Then AttachmentsList = "List of attachments: " & Chr(10) & Chr(10) & AttachmentsList Open "c:\temp\attachments.txt" For Output As #1 Write #1, AttachmentsList Close #1 End If Application.ScreenUpdating = True End Sub ===================================== Is there any way of printing my results instead of saving them into txt file ? Thanks for help. Tony |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I import text file of cash flow to excel file then use formula | Excel Discussion (Misc queries) | |||
Saving multi-tab excel file created from comma delimited text file | Excel Programming | |||
Excel VBA - open text file, replace text, save file? | Excel Programming | |||
Import text file into excel with preset file layout, delimeters VBA | Excel Programming | |||
Open delimited text file to excel without changing data in that file | Excel Programming |