Well, actually, I can't do that. I restore the clipboard after using it, so there's no evidence left.

As this problem occurs in any of a number of applications, I would have to recompile all of them.

Furthermore, the actual code is:

Select(lcExportAlias)
Goto Top
DataToClip(lcExportAlias)

So I know I am always atop the cursor.

I am sure something else is going on here.


>Then I would suggest that next time this operation fails you (or your user) paste the data into Notepad to see what it's being sent to the clipboard.
>
>
>>No, there is no issue here with the record pointer. If it were, it would be reproducible.
>>
>>DataToClip is actually used on a new cursor that is created for export, and the record pointer is at the top of that cursor.
>>
>>
>>
>>>>In all my grids throughout all my applications, the user can export any grid to Excel so that it looks, as much as possible, like the original grid. This is something that has been available for years and is used extensively.
>>>>
>>>>Every once in a blue moon, a user will report that the spreadsheet was created properly, with all headings and cell decorations, but without any data.
>>>>
>>>>The data is pasted in with copy that looks essentially like this:
>>>>

DataToClip(Alias)
>>>>loExcel.ActiveSheet.Paste()

>>>>
>>>>The user may repeat it a few times, failing each time, until, eventually, it works. It has happened to me twice. The most recent report was from somebody who exports from the same grid daily.
>>>>
>>>>Does anybody have any idea about what might be going on and what I could do about it?
>>>>
>>>>Thanks
>>>
>>>The scope of records that DataToClip sends to the clipboard is equivalent of REST. If Alias record positon is beyond EOF, then no records are sent to the clipboard. Are you controlling Alias record position before copying the data?