Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XLStart... | Excel Discussion (Misc queries) | |||
xlstart | Excel Discussion (Misc queries) | |||
XLStart doesn't always | Excel Discussion (Misc queries) | |||
XLStart directory | Excel Discussion (Misc queries) | |||
XLStart | Excel Discussion (Misc queries) |