autstat Support

icon
Avatar
felipe_carrillo
Posts: 5
I am trying to set a reference in Excel 64 bit to RCOM 1.0 Type Library : C:\Program Files\R\R-4.1.1\library\rcom\libs\x64\rcom_srv.tlb but I am getting a message: Run-Time error '-2147221164(80040154) Class not registered
This works well on Excel 32 bit but when trying it on Excel 64 bit doesn't work.

There are 3 files on the rcom >> libs : rcom.dll, rcom_srv.tlb, and StatConnLib.tlb
Do I need to register one or all of these? if so, how do I do it?
Thanks for your help.
2022-06-14 19:08
Avatar
Thomas Baier
Moderator
Posts: 222
Dear Felipe,

it might help to register, but on comRegisterRegistry() all required registration should already have been processed. Maybe you should try this while running 64 Bit R.

On the other hand, I have just looked up your license, and as using rcom is not covered by your license, you are definitely out of luck, even if the CLS_E_NOTREG goes away. Is there any reason, you think you will have to use rcom directly and not using the VBA interface provided by scExcel?

Best regards,
Thomas
2022-06-14 19:31
Avatar
felipe_carrillo
Posts: 5
Thanks Thomas. I didn't know about the licence, I thought rcom is freely to use with R.
I have not knowledge of scExcel, do I need a licence for that or there is a home-student version
for everybody to use?
2022-06-14 20:27
Avatar
felipe_carrillo
Posts: 5
Thomas;
I am interested in hearing more about scExcel. Is there a user's guide that I can read about it?
2022-06-14 20:34
Avatar
Thomas Baier
Moderator
Posts: 222
Dear Felipe,

please have a look at https://autstat.com/index.php/scExcel.html for more information about scExcel.

The Home&Student version of scExcel has to be renewed, as it has already expired, but this license won't allow you use in your job.

If you would like to get an evaluation version, please let me know.

Please use the web form at https://autstat.com/index.php/request-form.html.

Best regards,
Thomas
2022-06-15 11:23
icon