Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2009
    Location
    Hemet CA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Talking

    Are User Forms from Excel and Word, more or less one in the same? and if so is there a way to transfer a User Form from my Excel over to my Word.docm.

    The reason for this is I was using a couple worksheets from my Excel workbook and no longer need them and was also using Excel to navagate through User Forms back and forth to word docx that I use to do reports with. I thought I'd get rid of Excel and use just Word. Is this possible or can this be a problem. I would think it would be ok.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    User forms in Word and Excel are more or less the same, but you have to be careful with the code behind the form. A userform in an Excel workbook can use VBA specific to Excel, and a userform in a Word document can use VBA specific to Word.

    To transfer, you can export a userform from Excel and import it into Word:

    To export:
    - Open the workbook.
    - Activate the Visual Basic Editor.
    - Select the userform in the Project Explorer (the tree view on the left hand side of the Visual Basic Editor).
    - Select File | Export File...
    - Select a destination folder and click Save.
    - This will produce two files, one with extension .frm and another with extension .frx.
    - If you decide to move them, you must keep them together.

    To import:
    - Open the document.
    - Activate the Visual Basic Editor.
    - Select File | Import File...
    - Select the .frm file that you exported from Excel. and click Open.

  3. #3
    3 Star Lounger
    Join Date
    Jun 2009
    Location
    Hemet CA
    Posts
    310
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Talking

    Thank you HansV
    I was thinking in the same thing, but I just wasnt sure. I didnt want to try it first without knowing for sure. Simple enought thank you...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •