gj Rich. See... curiosity doesn't always kill that cat.
"RichS" <RichS@discussions.microsoft.com> wrote in message
news:2954C28A-B83A-44C7-886A-617DF431215C@microsoft.com...
> OK - think I've cracked it.
>
> have a look at this KB article
>
> http://support.microsoft.com/default...b;en-us;320369
>
> The problem is the culture the machine is set to. I'm in the UK so have
> en-GB - that clashes with Excel's en-US so won't work. I've chnaged all
> my
> location info to US and it now works. $host.currentculture shows en-US
>
> the code
>
> $xl = New-Object -comobject "excel.application"
> $xl.workbooks.add()
>
> now works. Brandon - I think you are US based so thats why it worked.
>
> Fix is to install MUI pack or to modify code in KB article for powershell.
> Easiest is to use MUI
>
> --
> 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
>
>
> "RichS" wrote:
>
>> 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
>> >
>> >