vlax command does not work - excel 2007 / windows vista

[vsereno]

I bought a notebook with excel 2007 and windows vista, and I've been using for long a lisp routine that reads values from a given excel tabel to make a draw in AutoCad. It worked very well with excel 97 / windows XP or windows 2000.

The error seams to be in the bellow command:
(setq excel-app (vlax-get-or-create-object "Excel.application"))

AutoCad command line returns :
error: COM exception: Error accessing the OLE registry , e depois dá...
error: no function definition: VLAX-GET-OR-CREATE-OBJECT

Wath to do ?
Thank for helping me,

Victor

[jwanstaett]

Check your registry for

HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Application

If it not there that way it not working.

Check for
HKEY_LOCAL_MACHINE\SOFTWARE\Classes\Excel.Application.12

This key shuld be Excel 2007.

Try

(setq excel-app (vlax-get-or-create-object "Excel.application.12"))

[dgorsman]

Sounds like you are missing a call to (vl-load-com) somewhere along the start-up.

[vsereno]

Thank you, but the problem is not the "missing a call to (vl-load-com)" ... it is there in the lisp program since 2003... it really sounds a problem of excel 2007 and/or windows vista...

Best regards,
Victor Sereno - Rio de Janeiro - Brazil ...

[irneb]

Does your Office 2007 have VBA enabled? Not sure if this is the case, but it may be as VL uses the ActiveX connections (which is basically VBA). VBA is supposed to become extinct, so M$ don't install it by default.

I had some probs with VBA code I did for Outlook 2003. Had to reinstall Office 2007 with custom & add VBA. Then my code worked. But then, that code didn't run from ACad ... worth a try though.

[vsereno]

IRNEB...
Thaks a lot, I will try to reinstall MSoffice 2007 with custom & add VBA....

Victor...