View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
chad chad is offline
external usenet poster
 
Posts: 273
Default 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