help with reg add fuction

Looking for some help on a reg add batch file. I am not sure what paramaters
need to be corrected.

It's simple - enabled the analysis toolpak for excel.

reg add "hkcu\software\microsoft\office\11.0\excel\options "\ /v OPEN /t
REG_SZ /d /r "C:\Program Files\Microsoft
Office\OFFICE11\Library\Analysis\ANALYS32.XLL" /f

The /r is part of the data value and that is where I am running into issues.

reg add "hkcu\software\microsoft\office\11.0\excel\options " /v OPEN /t REG_SZ
/d "C:\Program Files\Microsoft Office\OFFICE11\Library\Analysis\ANALYS32.XLL"
/f

you have a slash outside the quote after \options"\, remove that. you also
have a "/r" which in my instance of reg isn't valid. "/d" is the value data
assigned to the value name of "open"

"pete0085" wrote:

> Looking for some help on a reg add batch file. I am not sure what paramaters
> need to be corrected.
>
> It's simple - enabled the analysis toolpak for excel.
>
> reg add "hkcu\software\microsoft\office\11.0\excel\options "\ /v OPEN /t
> REG_SZ /d /r "C:\Program Files\Microsoft
> Office\OFFICE11\Library\Analysis\ANALYS32.XLL" /f
>
> The /r is part of the data value and that is where I am running into issues.
>
>

"pete0085" <> wrote in message
news:F25F5DF0-EBF8-4220-8E1F-...
> Looking for some help on a reg add batch file. I am not sure what
> paramaters
> need to be corrected.
>
> It's simple - enabled the analysis toolpak for excel.
>
> reg add "hkcu\software\microsoft\office\11.0\excel\options "\ /v OPEN
> /t
> REG_SZ /d /r "C:\Program Files\Microsoft
> Office\OFFICE11\Library\Analysis\ANALYS32.XLL" /f
>
> The /r is part of the data value and that is where I am running into
> issues.
>
>
as jford mentioned, you have a slash outside the quote after
\options"\ that should be removed.

As to the /r being a part of the data, you need to quote the entire
value since it has spaces, and since you want to include quotes within
the data the quotes need to be prefixed with backslashes, like so:

reg add "hkcu\software\microsoft\office\11.0\excel\options " /v OPEN /t
REG_SZ /d "/r \"C:\Program Files\Microsoft
Office\OFFICE11\Library\Analysis\ANALYS32.XLL\"" /f

Hope this helps.

--
Zaphod

Voted "Worst Dressed Sentient Being in the Known Universe" for seven
years in a row.