| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How To Create a Document in Excel from a Template, Using a Macro
Hi There,
Well its not QUITE as simple as the subject..... What i want to do is the following: I have a template called "Job000" I created a macro which automatically creates a new document from the template. When i run the macro, its creates a document called "Job0001" When i run the macro again, it again creates a document called "Job0001" What i want to happen is for it to automatically generate a different filename each time, specially "Job0002" - "Job0003" - "Job0004" - so on and so forth. I can not figure out how to do this, so i am hoping someone can help me. Many Regards Zach Nicodemous |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| create a template document, which when used will automate a number | Excel Discussion (Misc queries) | |||
| How to create a formatted 'readable' document based on Excel document? | Excel Discussion (Misc queries) | |||
| How to open xl and create a new document based on a template | Excel Discussion (Misc queries) | |||
| I want to create a template like invoice template in excel. | Excel Programming | |||
| Macro in template opens last saved document | Excel Programming | |||
Threaded Mode
