>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,
Why don't you use OLE automation with Excel which will give you full control on the appearance?
Of course it is more code...
Nick
Nick Neklioudov
Universal Thread Consultant
3 times Microsoft MVP - Visual FoxPro
"I have not failed. I've just found 10,000 ways that don't work." - Thomas Edison