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
|