Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to split an excel workbook in code and data
Subject: How to split an excel workbook in code and data
I have a complex excel file (.xlsm). It has several complex sheets and complex macros. This workbook (excel file) will be used by many different users who will enter data in the excel file and run macros. What I want is to split this excel file into two – “data” and “code”; so if any changes are required, they are made in one place “code” and this “code” excel file is included in “data”, so different users can enter different data, but “code” is same. Appreciate your expert opinion how to do it. I thought of following: 1. In one excel file “code” have all the macros. In the second excel file “data” have all the worksheets. I think this is doable. 2. In second approach, have all the Marcos as well as work sheets in one “code” excel file and data file initially is blank. I do not know if I include this “code” excel file in “data” file whether all the worksheets will show up. Advantage of 2 over 1, if there are any changes made in worksheet such as title, color changes; they will be available to all the users (similar to macro). Not sure 2 can be done. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stepping through VBA code, Excel not performing actions on split s | Excel Programming | |||
Split data from 1 workbook into multiple workbooks based on criter | Excel Worksheet Functions | |||
I want to Split & save the data in different workbook | Excel Programming | |||
Split Workbook - improved code required | Excel Programming | |||
split data in many workbook | Excel Programming |