XLSTART default
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 |
XLSTART default
Those settings are depending on Windows config.
Look at Tools-Options-... Probably it is: C:\Program Files\Microsoft Office\Office\XLStart Try to do this: Close Excel, Copy excel file with some data Open Excel If your file is open so... You know it's good path. Using: FileCopy srcFile destFile -----Original Message----- 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 . |
XLSTART default
Thank you
-----Original Message----- 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 . |
All times are GMT +1. The time now is 09:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com