mkirzon

I have created a Macro that depends on variables set by a user's input into textboxes within a User Form that I created in the same workbook.

As I want to provide this combination of macro/form for users that I do not want to have to copy code, or import the macro file or form file into each excel workbook they work with, I was wondering if there was a way to automate this.

Ideally, the macro and form would somehow be merged, and I have an executable(or equivalent) that allows me to use a windows browser to select the excel file into which to import the macro and form, and give a quick option to run (such as another message box or command button)

Is this achievable?

Thanks in advance.

ZKat

mkirzon,

Is there any reason you cannot build a an Excel template with your form and code and roll those workbooks out to your end users?

Why mess around with copying code at all?