Automatically including the Form and Code in all the user file

[ssexcel]

Greetings !

I have one workbook where I have created an USERFORM and 2
macros(modules). (for better understanding I would call this
PROG.XLS)

I want to use this USERFORM and the macro in multiple(different) excel
work books which contains data and which I receive from my client. (for
better understanding I would call this DATA.XLS)

I want to paste(?) the USERFORM and Macros from PROG.XLS to DATA.XLS
automatically (using VBA) so that I can start using DATA.XLS.

I am new to VBA and I would request you to take this into consideration
while providing help.

Also I would like to know if I save PROG.XLS as XLA file would the
USERFORM also be available for all the workbooks

Thanks in advance

 

[Bob Phillips]

You could set PROG.XLS up as a template, and just open this template when
ever you wanted that code.

If you want more complex VBA solution , take a look at Chip's site
http://www.cpearson.com/excel/vbe.htm

On the addin , the best way is to try it. As it happens the answer is yes it
would, but it is very simple to try and discover yourself (which is always
the best way to learn<vbg>).

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[ssexcel]

Just to add a few thoughts:
I think you have to differentiate using with and using in.

Tom Ogilvy

Thanks so much Bob and Tom for your help

Regard