auto update my code

I have a 10 different excel files with VBA code in them. If I make a change in one of them, I have to manually change the code in the other 9 files the have the same desired effect. How can I make it where all of the vba source code changes in all of them when I make a single change to one of them?

adam

AttachmentSize
WY2008 - Copy.zip143.69 KB
Nick's picture

read this

um...

So I guess I should have said I have office 2010. that being said, why do I want to download the concatenate range file from the link above?? that is not want I am wanting to do. I ought to be able to save my code in a file by itself somewhere, and have excel open that file each time so that my code is changed in my new code file, not concatenate a range; I know how to do that. I tried going to the developer tab, and then 'addins' and also 'com addins' but did not know what to do from there.

thanks
adam

Nick's picture

you've not read all of it,

you've not read all of it, have you...
; - >

yup I did!

Ya, I read all the way to the end to the excel add-in, I tried what it said in the 3 steps at the end, and I cant find it in excel 2010. I think that thread is referring to an earlier version of excel. the closest thing I have is in the Developer tab and then 'addins' or 'com addins'. Once I click on either of those I have no manage button like it says at the bottom of the thread you gave me.

Nick's picture

ok.. an Excel Addin is the

ok.. an Excel Addin is the way you can reuse your code across sheets... However, it has it's problems, so firstly try to answer this:

Is there any way you can merge all your sheets into one workbook ?

- this is by far the best solution.

merge data

I can't really merge my data. A month or so ago I took a job with a company that has a scientific data logger in a cave stream that collects water temp, turbidity, flow rates... and it logs a record ever 2 min to every hour depending on the changing water. They have collected it for the last 10 years and will continue to collect it forever. It is ALOT of data if you can imagine. they want a daily, monthly, and yearly max, min, and average of the data. I started by writing functions, and they work fine, but if I want to tweek it a bit, I have to tweek all of them in all of my files. Lets look at how to do what your talking about even though it has problems, which by the way what are the problems, mabe they will not affect me.

On another note, I had a guy tell me to use a pivot table. I tried, and could not make it only display say october 1st one time. I attached a file to show you what I did. the tabs at the bottom tell you want I need and have.

Nick's picture

undoubtedly the best place

undoubtedly the best place for this is in a pivot table.

- store all your data in a CSV, and link a pivot table to it

file

I attached the file at the top of the thread called WY 2008-copy. How can I make the pivot table look like what I have in that file?
adam

Nick's picture

ah ok... this isn't a small

ah ok... this isn't a small topic...

you can Request a Quote and I can get a developer to take a look... or maybe someone else can chip in