ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   tab delimited file (https://www.excelbanter.com/excel-programming/279432-tab-delimited-file.html)

Rod Tweedy

tab delimited file
 
Greetings,

I am experimenting with excel. What I would like to do is
import a tab delimited file into excel that maintains
column headings and colors. I accidentally discovered
that XML w/schema will do this. Does anyone know if the
good old tab delimited file can do the same. Thanks for
your time.

Nick Hodge[_3_]

tab delimited file
 
Rod

Tab delimited, comma delimited, etc are flat text files and carry no tags
for formatting, etc. You are stuck with HTML or XML or code to format it
once in

--
HTH
Nick Hodge
Southampton, England



"Rod Tweedy" wrote in message
...
Greetings,

I am experimenting with excel. What I would like to do is
import a tab delimited file into excel that maintains
column headings and colors. I accidentally discovered
that XML w/schema will do this. Does anyone know if the
good old tab delimited file can do the same. Thanks for
your time.





All times are GMT +1. The time now is 10:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com