VBA Automation operation

[blacjac]

Sounds like the Excel Automation Object has been removed, however I don't know if you can just install it from the Office CD.

Perhaps running the installer and 'fixing' the installation will do it....

[xoggoth]

Thanks Mr Robin but that construct give the same error.

Oh sod, tried system restore and not only did it not fix fault, it brought back another one I spent ages on a few weeks back. I HATE VISTA!!!!!!!!!!!!!!!!

[MrRobin]

I always use

Set someobject = CreateObject("Excel.Application")

and then

someobject.Workbooks.Open <<SpreadsheetLocation>>

to actually open it

When calling a spreadsheet from another Office program. Should be the same from a VB module...

[xoggoth]

From things on net looks like the damn thing has removed and unregistered DAO360.dll. But not sure about trying remedy as given on Vista, is version/path correct?

There is a DAO360.dll in a very long obscurely named directory that looks to me like a restore copy. Seem to recall a windows thing that automatically repaired lost/damaged system files but darned if I can remember how.

PS System restore does not work worth a damn on Vista.

[xoggoth]

I have a useful excel sheet that pops up when PC starts if there are any important deadlines. This is launched from a simple VB prog in startup. After installing and removing a rubbish drawing package yesterday this has stopped working.

The line

Set xlTmp = New Excel.Application

now gives Run time error 432
File name or class name not found during Automation operation.

Excel is working. Ran regcure and did not help. Cheers for any other ideas.