Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sporadic problems with Excel 2010
Message
 
To
16/08/2012 16:00:43
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01550587
Message ID:
01550807
Views:
41
Where is the paste information from? I've come across issues when copying from Outlook and trying to paste, not sure if it same exists across all Office applications.
~M

>Some of my users who have just begun using Excel 2010 are encountering some problems.
>
>All my program does is to take a cursor and plunk the data into an Excel spreadsheet (OK, it decorates the spreadsheet as well)
>
>However, every now and then, maybe 10% of the time, nothing from the cursor gets into the spreadsheet. The decorations do, so what
>the users sees is a partially filled out spreadsheet.
>
>The code looks like this (irrelevant stuff removed):
>
>
DataToClip (lcStruct)
>
>With loExcel
>	.Range(ExcelCellName(1,lnHdrRow)).Select
>	.ActiveSheet.Paste
>Endwith
>For the same user, sometimes this works, sometimes not.
>
>(This is part of some code that is maybe 4-5 years old and not re-visited much since then, but I simply
>cannot see how it could failed to write the data out some of the time).
>
>Of course, in earlier versions of Excel, all worked fine.
Go raibh maith agat

~M
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform