Done a bit of digging and found this
http://forums.microsoft.com/MSDN/Sho...68710&SiteID=1
look at the bottom posting in the thread. I'm just going to test it
--
Richard Siddaway
Please note that all scripts are supplied "as is" and with no warranty
Blog:
http://richardsiddaway.spaces.live.com/
PowerShell User Group:
http://www.get-psuguk.org.uk
"n3llyb0y" wrote:
> Hi All,
>
> I've recently moved to Vista but one of my scripts that was using
> office 2007 no longer wants to work. I was hoping someone could shed
> some light on this.
>
> I'm calling the excel application
>
> $xl = new-object -comobject "excel.application"
>
> Then try to add a new workbook
>
> $xl.workbooks.add()
>
> and get this error:
>
> Exception calling "Add" with "0" argument(s): "Old format or invalid
> type library. (Exception from HRESULT: 0x80028018 (TYPE_E_INVDATAREAD))
>
> any ideas?
>
> Cheers,
> Neil
>
>