Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Sporadic problems with Excel 2010
Message
From
16/08/2012 16:00:43
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
COM/DCOM and OLE Automation
Title:
Sporadic problems with Excel 2010
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01550587
Message ID:
01550587
Views:
87
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.
Jim Nelson
Newbury Park, CA
Next
Reply
Map
View

Click here to load this message in the networking platform