getline from a macro

[reddog9069]

I am involved in using a worksheet that has many macros that are constantly being updated.

There are many permutations of the same worksheet, but they all have the same macros.

Whenever I change the master template I then have to go through and update each permutation individually.

I have written a macro that will update automatically, but I want to use the first line as a tag on whether the individual module needs to be updated.

How can I read the first line of a module from within another VBA module?

Thanks

[Jim Thomlinson]

Take a look at this link which allows you to code to the VBE...

http://www.cpearson.com/excel/vbe.htm
--
HTH...

Jim Thomlinson


"reddog9069" wrote:

>
> I am involved in using a worksheet that has many macros that are
> constantly being updated.
>
> There are many permutations of the same worksheet, but they all have
> the same macros.
>
> Whenever I change the master template I then have to go through and
> update each permutation individually.
>
> I have written a macro that will update automatically, but I want to
> use the first line as a tag on whether the individual module needs to
> be updated.
>
> How can I read the first line of a module from within another VBA
> module?
>
> Thanks
>
>
> --
> reddog9069
> ------------------------------------------------------------------------
> reddog9069's Profile: http://www.excelforum.com/member.php...o&userid=24458
> View this thread: http://www.excelforum.com/showthread...hreadid=497580
>
>