RE: Formatting an EXCEL Worksheet Generated From The 400

Thank you for the tip... I though only the new versions of excel could read
the html layout....but my version of excel 97 read it correctly....

Thanks, tim

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [SMTP:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Reggie Acosta
> Sent: Friday, February 06, 2004 3:22 PM
> To:   midrange-l@xxxxxxxxxxxx
> Subject:      RE: Formatting an EXCEL Worksheet Generated From The 400
> 
> Recently, an associate, Ricky Thompson, gave me this tip. 
> He said, MS Excel will open a text file, formatted as an HTML 
> table, without any intervention if the file has a .xls extension. 
> Try it. Paste the HTML below into notepad and save it with the 
> .xls extension then open it in Excel.
> 
> You'll just need to create a the file with HTML table tags instead 
> of a CSV file. I'll leave that as an exercise for the reader. :)
> 
> <table border="1">
> <tr><td><b>Product Id</b></td><td><b>Description</b></td><td><b>On
> Hand</b></td><td></tr>
> <tr><td align="left">WIDGET-A</td><td align="left">A
> Widget</td><td>0</td></tr>
> <tr><td align="left">WIDGET-B</td><td align="left">B
> Widget</td><td>255</td></tr>
> </table>
> 
> HTH
> 
> Reggie Acosta
> Brown Jordan International
> 
> 
> >....however automation between the mailing out and the end-user 
> > opening it up in EXCEL would be great!!
> > 
> > Any ideas people?
> > 
> > Thanks much.
> > 
> > Rick Rayburn
> > NYC
>  
> 
> _______________________________________________
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
> list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: http://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at http://archive.midrange.com/midrange-l.
> 
This e-mail message, including any attachments, is for the sole use of the
intended recipient(s) and may contain confidential or privileged
information.  Any unauthorized review, use, disclosure or distribution is
prohibited.  If you are not the intended recipient, please contact the
sender by reply e-mail and destroy the message.