Hi,

Sorry if this is a FAQ - I did Google before posting but couldn't find
the answer.

I have both Excel 2003 and Excel 2007 on my machine. I want different
macros available in each.

So, I created (Windows XP):

Excel 2003: C:\Documents and Settings\MyUserName\Application Data
\Microsoft\Excel\XLSTART\***Excel11***\MyMacros.xls

Excel 2007: C:\Documents and Settings\MyUserName\Application Data
\Microsoft\Excel\XLSTART\***Excel12***\MyMacros.xlsb

(It appears the file doesn't have to be named personal.xls /
personal.xlsb, since all files in XLSTART are opened anyway).

In Excel 2003 I can change the location of the XLSTART folder: Tools
--> Options --> General --> At startup, open all files in ...

How do I make the same change in Excel 2007? I've even searched the
registry for a hack but couldn't find it.

Thanks,
Scott

Excel button
Excel Options
Advanced
General
At startup, open files in

Note as with 2003 this is in addition to the files in the XLstart folder
You might also want to make the alternate start folder a "trusted location",

Excel options
Trust Center
Trusted Locations

Regards,
Peter T

"Scott Bass" <(E-Mail Removed)> wrote in message
news:0fd482b5-e9c7-4e72-af35-(E-Mail Removed)...
> Hi,
>
> Sorry if this is a FAQ - I did Google before posting but couldn't find
> the answer.
>
> I have both Excel 2003 and Excel 2007 on my machine. I want different
> macros available in each.
>
> So, I created (Windows XP):
>
> Excel 2003: C:\Documents and Settings\MyUserName\Application Data
> \Microsoft\Excel\XLSTART\***Excel11***\MyMacros.xls
>
> Excel 2007: C:\Documents and Settings\MyUserName\Application Data
> \Microsoft\Excel\XLSTART\***Excel12***\MyMacros.xlsb
>
> (It appears the file doesn't have to be named personal.xls /
> personal.xlsb, since all files in XLSTART are opened anyway).
>
> In Excel 2003 I can change the location of the XLSTART folder: Tools
> --> Options --> General --> At startup, open all files in ...
>
> How do I make the same change in Excel 2007? I've even searched the
> registry for a hack but couldn't find it.
>
> Thanks,
> Scott

Doh! Thanks...

On Feb 24, 9:34*pm, "Peter T" <peter_t@discussions> wrote:
> Excel button
> Excel Options
> Advanced
> General
> At startup, open files in
>
> Note as with 2003 this is in addition to the files in the XLstart folder
> You might also want to make the alternate start folder a "trusted location",
>
> Excel options
> Trust Center
> Trusted Locations
>
> Regards,
> Peter T
>
> "Scott Bass" <sas_l_...@yahoo.com.au> wrote in message
>
> news:0fd482b5-e9c7-4e72-af35-(E-Mail Removed)...
>
> > Hi,
>
> > Sorry if this is a FAQ - I did Google before posting but couldn't find
> > the answer.
>
> > I have both Excel 2003 and Excel 2007 on my machine. *I want different
> > macros available in each.
>
> > So, I created (Windows XP):
>
> > Excel 2003: *C:\Documents and Settings\MyUserName\Application Data
> > \Microsoft\Excel\XLSTART\***Excel11***\MyMacros.xls
>
> > Excel 2007: *C:\Documents and Settings\MyUserName\Application Data
> > \Microsoft\Excel\XLSTART\***Excel12***\MyMacros.xlsb
>
> > (It appears the file doesn't have to be named personal.xls /
> > personal.xlsb, since all files in XLSTART are opened anyway).
>
> > In Excel 2003 I can change the location of the XLSTART folder: *Tools
> > --> Options --> General --> At startup, open all files in ...
>
> > How do I make the same change in Excel 2007? *I've even searched the
> > registry for a hack but couldn't find it.
>
> > Thanks,
> > Scott