Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
saving excel table as text file
Hi there I really hope someone can help me with this please. I have, in excel, x columns and y rows containing numerical data. What I need to do is first create and then save the table into a text file, but retain the original layout of the data. Any ideas would be greatly appreciated Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
saving excel table as text file
I'm not sure what retain the original format means, but if the data is the whole
worksheet, couldn't you just save a copy of that file as .prn or .csv? If the data is less than the whole worksheet, you could copy it to a new worksheet and save it from there? or: You may want to try Earl Kiosterud's Text Write program: It's available at Tushar Mehta's site: http://www.tushar-mehta.com/ Look for Text Write in the left hand frame. Or maybe write your own: Chip Pearson has some nice get-started code at: http://www.cpearson.com/excel/imptext.htm phillip harrison wrote: Hi there I really hope someone can help me with this please. I have, in excel, x columns and y rows containing numerical data. What I need to do is first create and then save the table into a text file, but retain the original layout of the data. Any ideas would be greatly appreciated Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! -- Dave Peterson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
saving excel table as text file
On Tue, 15 Jul 2003 00:35:38 -0700, phillip harrison
wrote in microsoft.public.excel.programming: [snip] To be clearer in what i need to do... I have imported a 1 column list of data from a text file into Excel and, using VBA have done various things with it one of which is arranging the data into a table like format. The reason I put "x columns and y rows" in my first question was because the VBA program I am writing will be run with many text file data lists and so each one will result in a different table size in excel. Anyway, the task i now need to do is, via VBA, save the table as a .txt file but the table format must be kept. By this i dont mean the font but simply that the value in cell B2 must be in the same position in the text file. Thanks Have you tried to save to a PRN file? Like so: someWorkBook.SaveAs Filename:="fubar.PRN", FileFormat:=xlTextPrinter -- Michael Bednarek, IT Manager, Tactical Global Management Waterfront Pl, Brisbane 4000, Australia. "POST NO BILLS" http://mcmbednarek.tripod.com/ |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
saving excel table as text file
Position in a text file means different things depending on how your text file
is formatted. Try saving it in .prn or .csv to see if that comes close to what you want. Maybe you don't need a macro at all. phillip harrison wrote: Dave, Thanks for the reply and I have checked out Tushar Mehta's site but unfotunately you need to download the code in a zip file and as Im at work our internet settings prevent any downloads. To be clearer in what i need to do... I have imported a 1 column list of data from a text file into Excel and, using VBA have done various things with it one of which is arranging the data into a table like format. The reason I put "x columns and y rows" in my first question was because the VBA program I am writing will be run with many text file data lists and so each one will result in a different table size in excel. Anyway, the task i now need to do is, via VBA, save the table as a .txt file but the table format must be kept. By this i dont mean the font but simply that the value in cell B2 must be in the same position in the text file. Thanks *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Seeing Text File Names when Saving Excel Files | New Users to Excel | |||
Saving Excel to Text file | Excel Discussion (Misc queries) | |||
Why Saving a file to a CSV, Excel does not put text into Quotes? | Excel Discussion (Misc queries) | |||
saving a text file to excel | Excel Worksheet Functions | |||
saving an excel file as text without text in quotes | Excel Discussion (Misc queries) |