>>>
set memowidth to 1023
>>>cFirstLine=mline(_cliptext,1)
>>>_cliptext=strtran(_cliptext, cFirstLine+chr(13),"")
>>>oRange.PasteSpecial()
>>>
>>>Now the "multiple tables" part begs knowing some details: do they need to be on the same page (in which case you may have to consolidate them into a single cursor first), or can they be one page at a time. In the latter case, Naomi's way is the simplest.
>>
>>I think he wants them in the same sheet. And I don't think the data could be combined into one cursor.
>
>In that case, paste one, go a few (Excel) rows below that, paste next table, calculate the next blank row, go a few rows below that, paste next...
Yes, using _VFP.DataToClip
If it's not broken, fix it until it is.
My Blog