How do I insert page breaks in .txt for use in excel? in Excel General Questions    |   |  Help   Search For:     In:   Office   Excel     Excel General Questions     Excel New users     Excel Application Errors     Excel Charts     Excel Programming     Excel Setup     Excel Worksheet Functions              JohnK 1/19/2007 10:44 AM PST   Question   I control the production of a semicolon delimited text file using SAS and would like to allow end-users to import it directly into excel with preset page breaks.     Was this post helpful to you?         Reply |   Top           Dave Peterson 1/19/2007 1:09 PM PST   Answer   Plain text files don't have page breaks. Maybe you could give them a workbook that contains a macro that imports the text file and does exactly what you want????? JohnK wrote: > > I control the production of a semicolon delimited text file using SAS and > would like to allow end-users to import it directly into excel with preset > page breaks. -- Dave Peterson     Was this post helpful to you?         Reply |   Top           JohnK 1/19/2007 3:23 PM PST   Thanks. Don't know what I was thinking. Great idea. "Dave Peterson" wrote: > Plain text files don't have page breaks. > > Maybe you could give them a workbook that contains a macro that imports the text > file and does exactly what you want????? > > JohnK wrote: > > > > I control the production of a semicolon delimited text file using SAS and > > would like to allow end-users to import it directly into excel with preset > > page breaks. > > -- > > Dave Peterson >     Was this post helpful to you?         Reply |   Top         Return to Microsoft Communities   Notify me of replies