Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro - save to current location vs excel default location | Excel Discussion (Misc queries) | |||
.XLA's Code Not Available? | Excel Programming | |||
I want to cylce through all the open .xla's as well as the .xls' | Excel Programming | |||
Mouse Location, Movement and Spreadsheet Location | Excel Programming | |||
Saving variables in XLA's | Excel Programming |