![]() |
|
#6
|
|||
|
|||
|
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! |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Changing single-quotes to double-quotes
|
Bobosmite | Word | 5 | 04-15-2013 06:40 AM |
| Crash when exporting | 237 | Outlook | 0 | 01-12-2012 01:12 AM |
| Help with *.tif exporting! | judicial85 | Excel | 1 | 10-26-2011 07:49 AM |
| Balky Curly Quotes | JamesT | Word | 0 | 01-23-2010 05:36 PM |
| format cells to automatically place quotes around text | dirtleg | Excel | 1 | 09-16-2008 01:52 PM |