Anyone OLEd to Excel 2010 yet?

[GriffMG]

Hi

I have a customer who can't use my Excel integration features since she got her new 'puter with Office 2010 on it. Before I go running around looking for the problem, has anyone else done OLE with Excel 2010 yet?

Martin

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[Mike Lewis]

Martin, do you mean using the OLE DB provider? If so, the answer's Yes. I've been doing that just this week.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro tips, advice, training, consultancy
Custom software for your business

 

[GriffMG]

Hi Mike

No, I mean OLE automation - opening a copy of Excel and puting info into it.

The culprit seems to be coming up with an error right at the onset using the CreateObject("Excel.Application") command.



Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[Nigel Gomm]

on that PC you may need to

CreateObject("Excel.Application.14")

There other threads around here where a similar thing happens to outlook.

Your create code may have to test/catch for different versions if the CreateObject("Excel.Application") fails.

or you can read the registry and find the latest version in
HKEY_CLASSES_ROOT\Excel.Application\CurVer


hth

nigel

 

[GriffMG]

Thank you Nigel

I will arrange to try that poste haste!

Martin

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[Olaf Doschke]

I made the experience you need to put DOEVENTS FORCE after CREATEOBJECT("Excel.Application") on Vista/Win7, regardless of the Office version. That's also valid for Word, Outlook or other Office Applications.

It seems you get a object reference to the COM automation object too early while it's still loading into memory.

DOEVENTS FORCE has shown to be sufficient to wait for the Office object to be up and running.

Bye, Olaf.

 

[GriffMG]

Olaf and Nigel


Well, I have tried both of those to no effect, albeit I now have error handling in place for when it fails...

Any other suggestions - the snags are that a) I don't have Office 2010 and b) I am on Vista not Win 7

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[Nigel Gomm]

2 options spring to mind.

1. reinstall office/excel.

2. bit of a long shot but worth checking before you reinstall.
A few years ago new pcs were coming with Norton AV installed. When the user uninstalled it it left references to itself in the registry.

Run regedt32 and find

HKEY_CLASSES_ROOT\Excel.Application\CLSID

then look for a key with that clsid number under HKEY_CLASSES_ROOT\CLSID.
(HKEY_CLASSES_ROOT\CLSID\{00024500-0000-0000-C000-000000000046})

Under that will be inprocserver32. Make sure that the (default) setting is blank. Norton was leaving a link to a now nonexistent dll.

(messing with the registry comes with a health warning. If you do change any settings save the key first to a .reg file so you can restore if necessary)

n

 

[GriffMG]

The user does have a VERY INVASIVE Norton security program on her PC... I will have a chat with her.

Martin

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[GriffMG]

M$ has a KB on this

http://support.microsoft.com/kb/982431

The new copy of office may have been installed in 'Click To Run' mode... where automation is not possible.

The application is streamed off the web!


Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[GriffMG]

Darn, I just got this back from the users manager:

Hello Martin,
Microsoft Office 2010 using a product key was downloaded over the internet.
There was no disc used.

Hope this information is of use.

I have asked her to uninstall 2010 and install 2007 (for which she has the disk).

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[GriffMG]

She has installed Office 2007 and it works fine - I can't be 100% sure that her 2010 installation was C-T-R but it certainly looks like it.



Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[craigber]

Do you really mean OLE automation? Object Linking & Embedding has gone the way of the Dodo and been replaced by COM Automation. That's what you want to look at.

Craig Berntson
MCSD, Visual C# MVP,

http://www.craigberntson.com/blog

 

[GriffMG]

Hi Craig,

I mean OLE Automation, although apparently it is now just called automation (and it is based on the Component Object Model)

Martin

B-)

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.