Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Sporadic problems with Excel 2010
Message
 
À
16/08/2012 16:00:43
Information générale
Forum:
Visual FoxPro
Catégorie:
COM/DCOM et OLE Automation
Versions des environnements
Visual FoxPro:
VFP 9 SP1
Divers
Thread ID:
01550587
Message ID:
01550807
Vues:
40
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform