Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Create dummy file structure?
I'm working on a template that will house several types of data --
some inputted directly into the workbook, other data being linked to multiple external workbooks. When I say 'multiple', I'm thinking one for every day of the year! In order to make the links to these external workbooks, I'd like to first create the exact file structure -- users can simply then 'save- as' over top of the existing workbook. Is there a way to create this file structure using VBA? That is, can I have Excel repeatedly 'save- as' the current workbook, using the date as the file name? The desired path would look like this: \\server\folder1\folder2\StoreName\January1.xls \\server\folder1\folder2\StoreName\January2.xls \\server\folder1\folder2\StoreName\January3.xls \\server\folder1\folder2\StoreName\January4.xls etc.... Ideas? TIA, Ray |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there any way to create a folder structure for tabs in a workbo | Excel Discussion (Misc queries) | |||
how can I create a dummy variable in Excel? | Excel Discussion (Misc queries) | |||
How do I create a Work Breakdown Structure (WBS)? | Excel Discussion (Misc queries) | |||
Create Directory Structure from Cell Value. | Excel Discussion (Misc queries) | |||
closing dummy file | Excel Programming |