I was upgraded from Win/Office 2000 to Win/Office XP. Among other changes
was my UserName folder. I've got Personal.xls in the XLSTART folder, but
all my custom macro buttons point to a Personal that's supposed to be in
emillis\Application Data\etc, rather than edward.millis\Application
Data\etc.

It would be nice if there was a setting I could change in Excel that tells
it to look in a different folder, or change the address of evey button vib
VBA - else I have to do them all one by one! ANy help wioth this?
Ed

You can use the Alternate Startup Directory. Go to the Tools
menu, choose Options, then the General tab. There, put your
folder name in the "At startup, open all files in" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Ed" wrote in message
...
I was upgraded from Win/Office 2000 to Win/Office XP. Among
other changes was my UserName folder. I've got Personal.xls in
the XLSTART folder, but all my custom macro buttons point to a
Personal that's supposed to be in emillis\Application Data\etc,
rather than edward.millis\Application Data\etc.

It would be nice if there was a setting I could change in Excel
that tells it to look in a different folder, or change the
address of evey button vib VBA - else I have to do them all one
by one! ANy help wioth this?
Ed

Thanks for responding, Chip. I think I might not have been clear, though:
Personal.xls is opening from the XLSTART folder as it should be, but the
folder path has changed with the update and the button were all addressed
with the previous folder path.

I was thinking I would need to iterate through every toolbar and button,
find the macro assignment address, and change that. I'm also thinking
that's too much trouble and it would be less time to edit each one manually!

Cheers!
Ed

"Chip Pearson" wrote in message
...
You can use the Alternate Startup Directory. Go to the Tools menu, choose
Options, then the General tab. There, put your folder name in the "At
startup, open all files in" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Ed" wrote in message
...
I was upgraded from Win/Office 2000 to Win/Office XP. Among other changes
was my UserName folder. I've got Personal.xls in the XLSTART folder, but
all my custom macro buttons point to a Personal that's supposed to be in
emillis\Application Data\etc, rather than edward.millis\Application
Data\etc.

It would be nice if there was a setting I could change in Excel that
tells it to look in a different folder, or change the address of evey
button vib VBA - else I have to do them all one by one! ANy help wioth
this?
Ed

Problem fixed. A bit more Google searching using some different terms
brought up a few discussions on this with some macro codes. Embarrassingly,
one thread was begun by me, asking about this same issue a while ago.
*sigh* Note to self - make a note to myself about problems I've fixed
before.

Thanks for helping, Chip.
Ed

"Ed" wrote in message
...
Thanks for responding, Chip. I think I might not have been clear, though:
Personal.xls is opening from the XLSTART folder as it should be, but the
folder path has changed with the update and the button were all addressed
with the previous folder path.

I was thinking I would need to iterate through every toolbar and button,
find the macro assignment address, and change that. I'm also thinking
that's too much trouble and it would be less time to edit each one
manually!

Cheers!
Ed

"Chip Pearson" wrote in message
...
You can use the Alternate Startup Directory. Go to the Tools menu, choose
Options, then the General tab. There, put your folder name in the "At
startup, open all files in" setting.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Ed" wrote in message
...
I was upgraded from Win/Office 2000 to Win/Office XP. Among other
changes was my UserName folder. I've got Personal.xls in the XLSTART
folder, but all my custom macro buttons point to a Personal that's
supposed to be in emillis\Application Data\etc, rather than
edward.millis\Application Data\etc.

It would be nice if there was a setting I could change in Excel that
tells it to look in a different folder, or change the address of evey
button vib VBA - else I have to do them all one by one! ANy help wioth
this?
Ed