Macros that open software

[Ron Strowger]

Can a macro export a range of cells to tab delimited into notepad, open word to open the notepad file, remove the tab between the cells (A, B, C, D...) and insert a manual line break then save it as text? I can do all this pretty easily with manual steps from excel on through word but it requires the time to open and close each program through the steps. I am just learning macros and this is a big learning curve.

 

[Macropod]

There is no need to use Word or Notepad for this: it can all be done directly from Excel. For example:

Sub Demo()
Dim i As Long, j As Long, StrOut As String
With ActiveSheet
  For i = 1 To 10
    For j = 1 To 10
      StrOut = StrOut & .Cells(i, j).Text & vbCrLf
    Next
  Next
End With
Open "C:\Users\" & Environ("UserName") & "\Documents\Output.txt" For Output As #1
Print #1, StrOut
Close #1
End Sub

The above code will output A1:J10 on separate lines in a file named Output.txt in your Documents folder.

 

[Ron Strowger]

Thank you. I will try it out. That will be very helpful.