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