Correct incarnation of #import for accessing excel?

[braulio-por-dios]

Hi guys,

I'm looking on the internet for the correct way is of using "#import" to access all of Excel's features.

Up to this point I always thougth "#import" would automatically import all the files in the "imported-files" section for each of the type-libs mentioned, such that it could resolve all the cross-references, but it seems that's not actually the case? If it would, I guess it would suffice to import excel.exe with some "renames" and such.

I see that the type-lib in my excel.exe has the following in the imported-files section:

'stdole2.tlb' {00020430-0000-0000-c000-000000000046}
'mso.tlb' {2df8d04c-5bfa-101b-bde5-00aa0044de52}
'vbe6ext.olb' {0002e157-0000-0000-c000-000000000046}

Then, "vbe6ext.olb" has this on it:

'stdole2.tlb' {00020430-0000-0000-c000-000000000046}
'mso9.dll' {2df8d04c-5bfa-101b-bde5-00aa0044de52}

So there is mso's DLL clashing with a different version of itself. All the references I could find on the internet seem to be too old, so I just wanted to ask what the correct incarnation of "#import" is used nowadays?

Thanks,

Continue reading...