VFP having problems writing to the clipboard

[brigmar]

My initial problem was to create a Multi-sheet Excel workbook from VFP sources as part of an automated procedure.

This ruled out using the COPY TO and EXPORT methods, as they create new workbooks.

So I went with Excel Automation, using the _VFP.DataToClip(,,3) command to copy my currently selected table in to the Windows clipboard, and then have Excel Paste into cell A1. This is done in a loop for each of the Sheets in the workbook.

Which works fine, for the most part.

However, some users running the report ran into problems which (to me) pointed to the _VFP.DataToClip() command NOT populating the clipboard; nothing is being pasted to Excel, and when I ctrl-V / shift-insert in another application, the clipboard is empty. We are all using VFP9 and in all cases, there is only 1 data session (the default).

Anybody else seen this problem, or have a workaround ?

 

[TamarGranor]

Unless memo fields are involved, I think it might make more sense to write out several workbooks using COPY TO, and then use Automation to consolidate them into a single workbook.

Tamar

 

[Mike Lewis]

Brigmar,

I don't know whether this will help, but I tried the same technique once, but it failed because the amount of data being passed to _VFP.DataToClip() was too big.

Unfortunately, I didn't keep a note of what "too big" was, and, in any case, this was several versions ago. But it put me off using _VFP.DataToClip() for this purpose.

Mike


__________________________________
Mike Lewis (Edinburgh, Scotland)

My Visual FoxPro site: www.ml-consult.co.uk

 

[baltman]

Export (groups of) DBFs to Excel Workbook QUICKLY faq184-3005