Excel Forms

B

Bre-x

Windows("Book1").Activate

ActiveWorkbook.VBProject.VBComponents.Import ("N:\1CNC\lathe\vba_excel.bas")
ActiveWorkbook.VBProject.VBComponents.Import ("N:\1CNC\lathe\UserForm1.frm")


Thank you all
 
S

SeanC UK

Hi,

You can copy code, whether in the form of a form or a module, to a newly
created workbook (or any workbook for that matter). However, I suspect that
the methods you employ will require your code having access to the VBA
Project Object Model.

You will then have to create references to the object using things like

myWorkbook.VBProject.VBComponents("ModuleName").CodeModule (this is for a
code module, as the name would suggest).

I'm not sure exactly how you could copy a form, I've used similar to add
code to new modules that I added into newly created workbooks. So the sort of
thing you are looking for is possible (even if it means your code would have
to create the object rather than copy it).

One thing, however, it is not recommended to allow access to the VBA Project
Object Model as it opens you up to allowing malicious code. If you're happy
that you're safe on that front then all well and good, but otherwise I'd
suggest that you remove access again afterwards just in case.

I know I didn't give you a direct method as to how to do this, but I'm sure
(judging from what you are trying to do) that you will be able to look into
this further yourself and find out exactly how to do it.

Hope this helps,

Sean.
 
Top