Hi,

Our company just upgraded from Office 97 to Office 2003. We have a VB
application that sometimes needs to launch Excel and run some macros.
When it needs to do this it copies the .xls file containing the macros
to
...\program files\office11\xlstart and then launches Excel. When the
app is done running, it removes this file from XLStart. So far we
have upgrades about 600 people and this approach seems to be working
for almost everyone. However we have had 3 cases where the file gets
copied to the XLStart folder and Excel gets started, but the file in
XLStart doesn't open.

It sounds like by default, Office 2003 wants to look in ...\documents
and settings\current user\..... for the xlstart folder. When we try
physically copying the file to this location on the computers that
aren't working, it works fine. My question is, why does Excel know to
look in program files\office11\xlstart in most cases, but doesn't know
to look there for these 3 cases?

Because each user is going to have a different value for the current
user part of the path in documents and settings, we don't know how to
get our VB code to copy the file over to the XLStart in that location
so we would like to figure out how to fix things in cases where it
doesn't know to look in the Office11 folder.

I hope I explained myself clearly here. If you have any ideas, I
would sure appreciate hearing from you.

Thanks