Attaching Excel VBA Form Code to Excel files 1

[hafod]

Hi
I have written a VBA application using a single Form object in excel and want to re use the same form in other, separate Excel files. The Form is basically a GUI viewer used to input, validate and view data for each 'record', but does have other more complex functionality and presentational features.

I know I can IMPORT component .bas, .cls, and .frm VBA project files but do need to automate this process for many users with limited IT literacy to use with worksheet files with similar data structures. Each spreadsheet, and there are many, (xls file)are exported regularly as data sets from a third party mainframe program and so a way of automating this 'VBA Form attachement' would be extremely helpful.

Many thanks in anticipation

Is there any way of doing this

 

[PHV]

Have you tried to play with AddIn (xla) ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[hafod]

Hi PHV,
Your post was helpful. I can now create and use xla functions effectively using on-line tutorials. However xla' sin context of my problem seem to relate to vba code modules. Can I assign graphical User form objects to xla' s. This is not clear in any references (many) I have looked at so far incl. tek-tips. Please help!!
Hafod