View Single Post
 
Old 02-16-2012, 06:21 PM
Chris1 Chris1 is offline Windows 7 64bit Office 2007
Novice
 
Join Date: Jan 2012
Posts: 4
Chris1 is on a distinguished road
Default Hey... Thank you!

I appreciate your response! Only as to help anybody else that runs across this issue (although your response would have done the same): I found a macro that would do this that may prove a bit simpler- MAY.. not 100% sure.
I actually did it all in visual basic (http://office.microsoft.com/en-us/ex...010014111.aspx) as adding a macro limited the amount of lines I could add for some reason:

Sub Export()
Dim r As Range, c As Range
Dim sTemp As String

Open "c:\YourFileName.txt" For Output As #1
For Each r In Selection.Rows
sTemp = ""
For Each c In r.Cells
sTemp = sTemp & c.Text & Chr(9)
Next c

'Get rid of trailing tabs
While Right(sTemp, 1) = Chr(9)
sTemp = Left(sTemp, Len(sTemp) - 1)
Wend
Print #1, sTemp
Next r
Close #1
End Sub

Copy/Paste- press F5 and it will export
Again- I appreciate everybody who helped figure this out!
Reply With Quote