OdinsDream
Well-known Member
- Joined
- May 19, 2002
- Messages
- 541
I'm playing with templates. I've created one XLT file and saved it onto a network drive. I've searched my entire C:\ for the file, and it is not there.
Yet, when I run this code:
Workbooks.Add ("Test Blank.xlt")
... which you'll notice does not include any Path information, a new workbook is opened based on the template in the network drive. I'm not sure I understand. Since I created the template on this computer, has excel memorised the location of that file?
Is there a way to open the actual XLT file first, then use the Workbooks.Add statement to create a new blank workbook based on the already-open XLT? That's my goal - to reduce the amount of times I'm accessing the network drive. If I could open the template once, and then create copies repeatedly based on it, that would be perfect. If I run the above code with the workbook already open, though, I get a conflict message about not being able to open an already-open workbook. So, Excel is just going back to the network again.
Yet, when I run this code:
Workbooks.Add ("Test Blank.xlt")
... which you'll notice does not include any Path information, a new workbook is opened based on the template in the network drive. I'm not sure I understand. Since I created the template on this computer, has excel memorised the location of that file?
Is there a way to open the actual XLT file first, then use the Workbooks.Add statement to create a new blank workbook based on the already-open XLT? That's my goal - to reduce the amount of times I'm accessing the network drive. If I could open the template once, and then create copies repeatedly based on it, that would be perfect. If I run the above code with the workbook already open, though, I get a conflict message about not being able to open an already-open workbook. So, Excel is just going back to the network again.
