Output to a delimited file (tabs, pipes, etc) as described by others here.
Download to your laptop or PC or wherever excel is running (like a windows
server maybe)
Start macro recording in excel
Import/format the delimited file, save as .xls
Turn recording off, save macro
Set the excel file to auto-execute the macro every time the excel file it's
opened, ie, reinput/format the delimited file. Then you can, e.g..,
schedule delivery of a new version of this delimited file whenever you'd
like, to your server. When people open it they would automatically get the
formatted version of the new data.
... or something like that, it's been awhile..
-John Hohn
Comp Three Inc.
On Wed, Nov 4, 2015 at 3:52 PM, Charles Finley <[log in to unmask]> wrote:
> There seem to be at least two steps to what you are trying to do.
>
> 1) Remove the headers, footers and perhaps page numbers from the report.
> 2) Remove the ff or CNTL characters from the text file.
> 3) Import a space delimited file to Excel.
>
> There are any number of different scripting tools that can do this
> including various UNIX tools. Here's a reference to Excel solution that
> might get you started. In fact, if it were my problem to solve, I would
> likely do it all with Excel scripting.
>
>
> http://www.mrexcel.com/forum/excel-questions/680923-removing-multiple-headers-imported-text-file.html
>
> We've done similar things over the years and I'm afraid Tracy is correct
> in his assessment that this is a specific problem that requires a certain
> amount of custom effort to achieve. If you don't have time to learn the
> scripting skills that are needed you may need to pay someone to do it for
> you.
>
>
> Charles Finley
> (619) 795-0720
>
>
> -----Original Message-----
> From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On
> Behalf Of Tim O'Neill
> Sent: Wednesday, November 04, 2015 1:45 PM
> To: [log in to unmask]
> Subject: Re: Mpe: From Spool File to Excel
>
> Thank you.
>
> The header (repeated every time there was either a "page eject" or "form
> feed") was created by the Editor (TDP) which went as follows:
> -Top of page
> -Header
> -Lines of report until end of page
> -Top of page
> -Header
> -Lines of report until end of page
>
> However Editor apparently counted lines, because when I print with smaller
> font size (thus higher pitch,) it leaves a lot of white space at the bottom
> of each printed page.
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
>
--
1585 The Alameda, Suite 101
San Jose, CA 95126
(408) 560-0141
www.compthree.com
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|