Hi Eimund,

The project has been postponed and I have had a few other problems to sort
out, but no - I still get strange results. I will post any info. that comes
to light.

Regards,
--
John Austin


"eimund" wrote:

On 28 Des 2007, 00:25, John Austin wrote:
Hi Jialiang,

The issue is complex, but I will do some tests and get back to you.
--
John Austin



"Jialiang Ge [MSFT]" wrote:
Hello John,

According to your description, my understanding is:
1. TheExcelautomation client was fast withExcel2000 or 2003
2. TheExcelautomation client became slow after the installation ofExcel
2007
3. TheExcelautomation client suddenly turn fast possibly due to the
installation ofExcel2007SP2
4. TheExcelautomation client became slow again after one week. But we do
not know the reason. Reboot does not help, either.

Is it correct?

I am still wondering which reason (1,2,3 or 4 as is mentioned in my last
reply) slows your application. Would you help me do the test in your side,
and let me know the result? Knowing the phase that affects the performance
can help us narrow the focus. Have you ever tried the suggestions in reason
3/(a)(b)(c) of my last reply? What is theexcelfile format (xls or xlsx)
when you imported the data? You may also try to manually insert data into
an xlsx file in yourExcel2007and see if it performs in an expected speed.

I did a test with anExcel2007automation client. Its performance is
acceptable in my Windows Vista 32bit Enterprise,Excel2007Enterprise,
Intel P4 3.0GHz, 2046MB RAM system. I understand that we didn't make
progress on this issue so far. It's mainly because the issue is not
reproducible and seems random. Would you send a sample project to my
mailbox )? I will test the project in my side and see
if the issue is persistent.

Happy New Year!
Regards,
Jialiang Ge , remove 'online.')
Microsoft Online Community Support

=================================================
When responding to posts, please "Reply to Group" via your newsreader
so that others may learn and benefit from your issue.
=================================================
This posting is provided "AS IS" with no warranties, and confers no rights.- Skjul sitert tekst -

- Vis sitert tekst -

Hi John!

Have you found any solution to your problem?
As I read this thread above, I recognize much of what you are writing.
I have a project myself that uses VBA macros to extract data from a
SQL Server 2005 database, I'm using Excel 2007 (Windows XP) and when I
try to copy the recordset to a cell in a worksheet, it takes a huge
amount of time, if it finishes at all! Often I need to just end the
excel application and start over. It works ok in excel 2003, but not
in the 2007 edition.

Regards,
Eimund