View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Maury Markowitz[_2_] Maury Markowitz[_2_] is offline
external usenet poster
 
Posts: 119
Default location for XLA's that I can easily get to

I have two small XLA's that I would like to load whenever a user opens
Excel. These are periodically updated, and will have to be copied down
every so often. To ease this task, and initial setup, I want to have
an application that will copy these off a network drive onto the local
machine. I have already made something similar to update an Access
app.

The only thing that's stumping me is where to put these. I think I
want to put them in the XLSTART folder - right? Will XLA's in the
XLSTART automatically load when Excel is opened?

If this is the right place, how do I find _this users_ XLSTART? I used
this for the Access app:

pth = Nz(Environ("USERPROFILE"), "C:\Documents and Settings\All
Users")
desktopPath = pth & "\Desktop\"

But that's because we wanted it on everyone's desktop. What's the
corresponding entry for "this users XLSTART"?

Thanks!

Maury