LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default VBA- how retrieve source dir for the template *.xlt file ?

welcome.


I have a template file test.xlt existing in some dir other than excel
templates dir.
When the file is launched new workbook is created and i want to autosave it
in a dir
where the test.xlt file exists.
Due to fact that instance of the file test.xlt does not longer exists i cant
get source dir.

I would be thankful for any hint.

PS.
i have used a tip that every single file launched makes its mark in a
windows recent directory,
so i found a link file (test.xlt.lnk) but a dont know how to retrieve target
dir from it.
Maybe this way ?


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Link a Master Template Excel file to different excel source files Jean Excel Worksheet Functions 0 August 2nd 07 11:12 PM
If I accidently replace a saved file can I retrieve the old file? kamabiv Excel Discussion (Misc queries) 1 May 11th 05 10:26 PM
Connect a Template with the data source. Bob Excel Programming 1 July 30th 04 08:56 PM
How do I retrieve Chart Source (range) and PlotBy Gilroy Excel Programming 1 June 24th 04 09:23 PM
Need template source path Don DeCosta Excel Programming 2 October 1st 03 03:20 AM


All times are GMT +1. The time now is 01:29 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"