Basically I have a workbook called Control Form. In this Control Form there are 7 Sheets.
The first sheet is the
Main Control that will control certain information on all the forms that VB Code will create, such as date, creators name,
The Second Sheet is called REV LEVELS and will control drawing level revisions for all of the sheets that the
VB code will create.
All this information above has already been linked to the sheets which VB will be creating
from the templates located in the Control Form Workbook. You should not have to worry about any of that.
sheet is called FileCreator, where there will be a command button which is called "Create Files" which, when
clicked on will create seperate workbooks, each with 4 sheets containing the templates located in the Control Form
highlighted in blue (Form 1, Form 2, Form 3, and Notes). The Code will need to name each file according to the Part Number
located on the FileCreator Sheet in the Control Form Workbook. Although nothing special needs to happen with the notes sheet
before it is transferred, Form 1 will need to get the Part Number, Part Name, and Drawing Number plugged into the
corresponding locations before it is copied to a new workbook. Since Form 2 and Form 3 have linked to Form 1 already I am
hoping that when the 3 forms are transferred they will stay linked together.
I tried to run a test on this just by
highlighting the 4 sheets and copying them to a new workbook but it tells me it cannot copy them as a group because one of
the sheets contains a list. (Form 1 contains a list to select the different Drawing Numbers) Let me know if this is going to
be a problem, if so I can do without the list.
Also the location where all the new workbooks will be saved is
whatever the folder location is of the Control Form.
Hopefully that all makes since..
Please ask any
questions for clarification. This seemed like quite an operation to me but I wanted to give it a try as we are currently
manually copying a workbook containing the 4 blue sheets and renaming everything manually. I have a job coming up where I am
going to need close to 250 different Part Numbers and if I could get this code working before it will save me a lot of
Thanks a bunch for your help!!
FYI The Control Form has been attached so you can play around with
it and get a better idea of the flow..