Export selected cells to text file <! - Save as text file export export make selected region text -> Free Excel Macros (VBA) | Excel Programs

Copy Macro

'For online Excel courses click: https://www.excelsizeyeter.com/excelwithkenan.com/udemy_giris.php 
Sub Secili_Bolgeyi_Text_Dosyasi_Olarak_Kaydet()
    'Bu işlem, seçtiğiniz bölgeyi D sürücüsünün içerisinde bir text dosyası olarak kaydeder.
    Call ExportRange(Selection, "D:\text_dosyasi.txt", ",")
End Sub

Function ExportRange(WhatRange As Range, Where As String, Delimiter As String) As String
 
 
 
Dim HoldRow As Long    'test for new row variable
 
    HoldRow = WhatRange.Row
 
 
 
Dim c As Range    'loop through range variable
 
 
 
For Each c In WhatRange
 
    If HoldRow <> c.Row Then
 
        'add linebreak and remove extra delimeter
 
ExportRange = Left(ExportRange, Len(ExportRange) - 1) & vbCrLf & c.Text & Delimiter
 
        HoldRow = c.Row
 
    Else
 
        ExportRange = ExportRange & c.Text & Delimiter
 
    End If
 
Next c
 
 
 
'Trim extra delimiter
 
ExportRange = Left(ExportRange, Len(ExportRange) - 1)
 
 
 
'Kill the file if it already exists
 
If Len(Dir(Where)) > 0 Then
 
    Kill Where
 
End If
 
 
 
Open Where For Append As #1    'write the new file
 
Print #1, ExportRange
 
Close #1
 
 
 
End Function

No	Macro Name
1	Export selected cells to text file
2	excel operators hk
3	Convert all texts in the selected region to lower case
4	automatic image fetch
5	Â AdvancedSome of the code you can use to prepare an advanced task in your electrical tables. Select the selected Range as PDF: Select a range Run this macro and obtain a PDF file for the selected range. This is really cool.
6	List the names of Excel files in a folder then give them a link
7	Search for a text / text in all open Excel files
8	Save Each Worksheet as a Single PDF: This code simply saves all worksheets in a separate PDF file. You just need to change the folder name of the code.
9	send alert e-mail from microsoft outlook
10	copy cells as images
11	email selected cells
12	Assigning random numbers as a value to cells in the selected region
13	saves data
14	who opened the file
15	txt who opened the file on what date
16	Who opened the file 2
17	a lot of dialog windows
18	deletes data
19	creates folder with book name save each sheet / page separately
20	Determining the name of the sheet / page and file containing the active cell

Excel Free Macros (VBA)

Export Selected Cells To Text File

Online Excel Courses

Services

How can we help you?

Subscribe to our Youtube Channel?

Keywords