Multiple Excel Sheets into one tab-delimited file - horizontal paste

[bluetik]

Hi -- wondering if anyone can help me. I have a file with 725 fields
currently sitting in an Excel workbook across 3 worksheets. I need to
do some work on it there, then export the results back into one giant
tab-delimited file with 725 fields.

I've searched and seen plenty of posts about exporting multiple sheets
where the sheets need to follow one another vertically (EG, additional
records) in the text file, but mine need to follow horizontally (EG,
additional fields).

I don't know if I'm being clear, but hope someone can help.

Thanks,
Char

 

[Tom Ogilvy]

You can write it out yourself:



http://web.archive.org/web/20040405...scid=/support/excel/content/fileio/fileio.asp
File Access with Visual Basic® for Applications


http://msdn.microsoft.com/library/en-us/dnofftalk/html/office09072000.asp
Working with Files, Folders and Drives: More VBA Tips and Tricks by David
Shank

http://support.microsoft.com/default.aspx?scid=kb;en-us;151262
Working with Sequential Access Files

http://www.applecore99.com/gen/gen029.asp


less applicable for your situation I would think:

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnclinic/html/scripting03092004.asp
ADO And Text FIles