>I'm developing an app where the results should be appended to an existing Excel table. I've tried the _vfp.datatoclip() and it works perfectly, except for a couple of glitches:
>
>I'm using format 3 (delimited with tabs), which pastes fine in Excel, but it seems to need some extra formatting afterwards. Excel expects character fields to be trimmed, and it loses most of the column formatting. The appearance of the field names is another unnecessary headache - I'd have to remember to delete it afterwards.
>
>I'm thinking of building the _cliptext string in this tab/cr delimited format, trimming where necessary etc. Is this the better way to do it? Or has someone already walked this path and knows of a more efficient way?
Hi Dragan - I haven't tried fiddling with the _cliptext, but it's fairly easy to edit the Excel sheets from vfp using cell, row, column, etc., commands combined with vfp code, after you do the paste...It's virtually like having two languages at your command simultaneously :)
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.