Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulate Excel
Hello. I create alot of spreadsheets. Whenever one is nearly done, I add
some additional code and forms to the spreadsheet. The same code/forms are added to each spreadsheet. I was wondering if there was a way I could automate this. I pretty much want to create some code that will actually create code in the spreadsheet's VBA environment. Is it possible to do something like this in VBA or even VB 6? I know you can do it in VB 6 for that environment. I just haven't been able to figure it our for Excel. TIA, Bich Leu |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulate Excel
You'll want to save your code/forms into a single XLA file.
Then you can load that xla file with any number of XLS files and have access to the code/forms of the single XLA. This way you can manage your code from one source. When you save-as XLA, Excel will try to force your XLA file to the Add-in directory but it can actually be saved and loaded from a network drive without a problem. One note of caution...make sure the xla file is read-only to regular users or else they will blow it up and you may want to add protection to it to prevent them from looking at the code depending on how paranoid you are...like me. -Kevin -----Original Message----- Hello. I create alot of spreadsheets. Whenever one is nearly done, I add some additional code and forms to the spreadsheet. The same code/forms are added to each spreadsheet. I was wondering if there was a way I could automate this. I pretty much want to create some code that will actually create code in the spreadsheet's VBA environment. Is it possible to do something like this in VBA or even VB 6? I know you can do it in VB 6 for that environment. I just haven't been able to figure it our for Excel. TIA, Bich Leu . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulate Excel
the easiest thing to do is save it into your persanal
macro book. (when you record macro it asks you where you what it) Once you did that, you should be able to use code and forms for any file without putting code in each file. Tahnks |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Manipulate Excel
Thank you both. Much appreciated!!
Bich |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I manipulate an excel chart by clicking and verify the ta | New Users to Excel | |||
How do I manipulate data pulled from within an excel calendar? | Excel Discussion (Misc queries) | |||
Excel: How to insert carriage returns in a formula to manipulate t | Excel Worksheet Functions | |||
Manipulate an excel column | Excel Worksheet Functions | |||
excel 2000 - manipulate two applications | Excel Programming |