Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Simple shared code library, also how to find spreadsheets with macrosin them
Hello all!
I started learning Excel VBA scripting informally a few years ago, and have been putting together increasingly complex utility scripts on an as needed basis. I've now gotten to the point where I've rewritten this stuff enough that I'd like to collect and modularize some of this code in a more reusable way. I'm more of a LAMP / *nix developer, so I'm hoping to be able to come up with a fairly lightweight solution that doesn't require a heavyweight switch in my development tools (e.g. switching to Visual Studio). I also have been informal (=lazy) about tracking the macros I've written, so I have two questions for you: #1. Is it possible to somehow scan for or otherwise locate spreadsheet files that have macros or scripts in them, so that I can collect all the VBA functions I've written? #2. If I want to collect all of these VBA functions and snippets into a centralized location (vs cloning them in each spreadsheet I want to use), what is the easiest way to do that? I know it is possible to put this code in separate "Module" files, but I don't really understand where those are stored or how you would deploy them (I'd like something I can have on multiple machines, ideally via SyncToy or something similar). Thanks! Ramon |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Saving shared spreadsheets on a shared drive. | Excel Discussion (Misc queries) | |||
Issues with shared vs. non-shared formulas on somewhat wide spreadsheets | Excel Discussion (Misc queries) | |||
best way to set up macro library so all spreadsheets have access? | Excel Programming | |||
shared spreadsheets | Excel Discussion (Misc queries) | |||
Code to fix: 'can't find project or library' | Excel Programming |