As suggested, I've revisited the SweetPotatoFactory solution and this time I got it to work Sweet. Real happy now I couldn't work out the CopyToExcel function, but that wasn't what I need anyway
Thanks folk. The Fox is NOT dead S On Wed, Jul 28, 2010 at 8:47 AM, Malcolm Greene <[email protected]> wrote: > Sytze, > > You can also use textmerge() to create an html file with your data in an > html table format and have Excel import this file. > > Example format (untested) > > Repeat the table row format for every row of data you want to output. > > <table> > <tr> > <td> column 1 data </td> > <td> column 2 data </td> > ... > </tr> > ... > </table> > > Note: You will also need to use strtran() to map '&' to '&', '<' to > '<' and '>' to '>' before outputting your data between the table > cell (<td>, </td>) tags. > > We've had good luck with this technique in the past. > > Malcolm > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
