try:
msgbox application.StartupPath
Todd Huttenstine wrote:
Hey guys,
I need to programmatically copy a file to the XLSTART
folder. Also what is the default location of the folder
because I did a search on my computer and saw the
following paths...
C:\Documents and Settings\Administrator\Application
Data\Microsoft\Excel
and
C:\Documents and Settings\Default User\Application
Data\Microsoft\Excel
and
C:\Program Files\Microsoft Office\Office
I am assuming if I want to put a file in the XLSTART
folder I would use the
C:\Program Files\Microsoft Office\Office
path. Im not sure though.
The file I want to put in that folder is located in
C:\ImportData.XLS
What is the code to copy the source file(ImportData.XLS)
to the destination XLSTART folder?
Thank you
Todd Huttenstine
--
Dave Peterson