View A Word Document On A Userform

  • Hi,


    Sorry if this sounds completely weird, but I've been banging my head against the wall for a wee while now.


    What I basically want to do is display a Word document within a UserForm.


    The UserForm happens to be in Excel.


    To complicate matters, the Word Document is protected (my excel App knows the password, it exported the file to begin with).


    I know you can select a "Microsoft Office Spreadsheet 11.0" from the toolbox, however I can't see a similar control for a Word Document.


    Is this even possible? Any help greatly appreciated! : D


    Scott

  • Re: View A Word Document On A Userform


    Not sure there is a comparable control for word.


    If you only want to show the document then you could save the word file as html and use the webrowser control on the userform.

  • Re: View A Word Document On A Userform


    Hi,


    Thanks for the reply. Yeah, that's what I'm doing at the moment, however we could be talking about 5000-7000+ forms per year once it's rolled out, and storing them in both formats could take up a lot of space!!! :)


    Scott : D

  • Re: View A Word Document On A Userform


    Yeah, I suppose so, but then you are adding a fair delay to the whole process. : D


    I will certainly continue to use this workaround if I can't actually display the word doc itself, but it would be nice if I could just add a component to the form, and tell it to load the required file (wishful thinking maybe). :)


    Thanks


    Scott : D

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!