Error 430

[Jose]

I have a function where a export data to excel via automation.
It was working good until today. I never had problems.
Today, I don't know what's happen in my computer, the function doesn't
export the data to excel.
It shows the error 430: Class does not support Automation or does not
support expected interface.

I just remove the office, I installed and the erros still existing.
Any help?
Thanks
JCP

 

[Maurice]

Did you automate via hardcoded versions of Excel? I mean if you automate
Excel by creating Excel as an Object it won't be an issue which version of
Excel is installed. If you specify the excel version it might collapse on
that.

 

[Jose]

Maurice, in this computer the code worked fine, I cpy the mdb and I opened it
and it works fine. From yesterdary in this computer tjhis function doesn´t
work.
The references is ok, I debug and is ok.
Do you have any suggestion?
thanks
JCP

 

[Maurice]

Jose post your code to excel here so we can check it out...