Results 1 to 7 of 7
  1. #1
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    add a word ... (2000 sr 1)

    this file contain a form with excel file, my proiblem is to insert a word file ... what is the just way?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: add a word ... (2000 sr 1)

    You used a Microsoft Office Spreadsheet Control on the userform. There is no equivalent Word Control. The nearest you can get is the Microsoft Rich Textbox Control; this can display formatted text and RTF documents, but not Word documents.

    If you like, you can open a Word document from Excel in Word itself, for example using the ActiveWorkbook.FollowHyperlink method.

  3. #3
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: add a word ... (2000 sr 1)

    TKS. For the help. Do you like to reattache with this solution "...If you like, you can open a Word document from Excel in Word itself, for example using the ActiveWorkbook.FollowHyperlink method" Tks.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: add a word ... (2000 sr 1)

    Salvatore,

    I have attached a small workbook with a userform. The userform contains a label and a command button. You must change the caption property of both to the path and file name of an existing Word document. When you have done that, you can run the userform and click the label or command button.

  5. #5
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: add a word ... (2000 sr 1)

    TKS. Are very gentle...

  6. #6
    Gold Lounger
    Join Date
    Jan 2004
    Location
    Italy
    Posts
    3,245
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: add a word ... (2000 sr 1)

    OK! but if in another pc the component RichTextBox1 is not present this how to install.?
    In effect i have send the .xls file and appear error: "Compnent not installed"

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: add a word ... (2000 sr 1)

    You need to have Office Developer Edition or Visual Studio/Visual Basic to have the right to distribute the Rich Textbox Control. If you do, you can make an installation package that will install the control on the user's PC. If you don't, the Rich Textbox Control is not a good solution for your problem.

Posting Permissions

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