Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #6  
Old 02-16-2012, 06:21 PM
Chris1 Chris1 is offline Exporting without Quotes Windows 7 64bit Exporting without Quotes Office 2007
Novice
Exporting without Quotes
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Exporting without Quotes 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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:36 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft