Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import From with macro
Is it possible to write a macro that will import an existing form?
Thanks for all your help! -Chad |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import From with macro
Import a userform from a file? Su
ActiveWorkbook.VBProject.VBComponents.Import "c:\UserForm1.frm" -- Jim "Chad" wrote in message ... | Is it possible to write a macro that will import an existing form? | | Thanks for all your help! | -Chad |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import From with macro
hi,
if you are just import 1 form it might be better to do it manually. open the file that has the form in it. open the vb editor (alt + F11) in the project window(far left), expand the project(filename) and right click the form click export. it will export as a .frm file. you may wish to export to a floppy disk which can be transfer to other pc's easily. close the file open the file you want the form in. open the vb editor in the project window, expand the project right click the project name and click import from the dialog box, select the form that you just exported and click ok done regards FSt1 "Chad" wrote: Is it possible to write a macro that will import an existing form? Thanks for all your help! -Chad |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import From with macro
Thanks for the response. However, I am capable of doing it manually, but I
would like to do it within a macro. Is it possible to write this within a macro? Thanks, Chad "FSt1" wrote: hi, if you are just import 1 form it might be better to do it manually. open the file that has the form in it. open the vb editor (alt + F11) in the project window(far left), expand the project(filename) and right click the form click export. it will export as a .frm file. you may wish to export to a floppy disk which can be transfer to other pc's easily. close the file open the file you want the form in. open the vb editor in the project window, expand the project right click the project name and click import from the dialog box, select the form that you just exported and click ok done regards FSt1 "Chad" wrote: Is it possible to write a macro that will import an existing form? Thanks for all your help! -Chad |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Import From with macro
That's perfect! Thank you very much!!!
-Chad "Jim Rech" wrote: Import a userform from a file? Su ActiveWorkbook.VBProject.VBComponents.Import "c:\UserForm1.frm" -- Jim "Chad" wrote in message ... | Is it possible to write a macro that will import an existing form? | | Thanks for all your help! | -Chad |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Import macro | Excel Discussion (Misc queries) | |||
Import macro from another workbook by macro | Excel Programming | |||
How to delete & import a macro | Excel Programming | |||
Import and run Macro | Excel Programming | |||
Macro import | Excel Programming |