Open Word Document from Excel VBA UserForm

This video demonstrates how to open a Microsoft Word document from an Excel VBA UserForm. The Word document names are stored as a variable in an Excel workbook and opened using VBA code.

[@goldenwoof]

Very informative, clear, and easy to follow. Thanks very much!

[@Technicalvidz]

fantastic, wish you best of luck in future. This is very useful i never seen before. Thanks

[@zureezee1887]

I like this video especially since I'm not tech savvy, the step by step directives would allow anyone to open word document from an excel VBA user form

[@mirandat1087]

I've seen something this before in Excel but it was created by someone else. I tried to replicate it on my own and failed and I can now see where I went wrong (pretty much everything). The instructions presented here are easy to follow and I am confident that I could do this!

[@dwiastuti4719]

Miranda T Hey Miranda, are you still use macro? And are you ever practice this tutorial?

[@happymm2008]

Dr Todd, this is great tutorial. It is very helpful. However, my word files are in sharedrive in another path and folder . Do you know how to write the code to open word file in different path not same as this workbook path? Thank you so much!

[@anahgalloway2740]

This tutorial was very easy to understand and follow until it started explaining creating the code for opening the file since I am so unfamiliar with coding. I am not sure when I will need to use this type of function in excel, but if I do, I think that this tutorial will be helpful to follow slowly step-by-step.

[@jassrana5840]

Hi Dr. You make me feel hopefully, Actually i was using mail merge features from work for making self declaration form for staff. But i want that word file will work automatically . With one click .(open-startmailmerge-makeform-close) from excel. Can you help please

[@asaqarbeh4724]

I have used Command button instead of userform but the document shows no content at F5

[@gusTechnikPro]

And how do you check if a file is already open?

[@lmt125]

Great tutorial! How would I go about if I wanted it to open pdf in another folder path?

[@lmt125]

+lmt125 In case someone needs this too. What I did to be able to open a pdf directly from a userform is : 1. Created a text box called File Link 2. In that text box the person puts the file path 3. A command button to open file 4. For code I did this : Dim Path As String Path = textbox1.value or in mycase UserForm1.textbox1.value (because this is calling info from that userform) ActiveWorkbook.FollowHyperlink Path This works great =)

[@tongapo9361]

is it posible to make VBA, that open 2 or more word doc from selected raws ot the excel table at one click on button?

[@violetasull]

I have the same question

[@Robertyaro]

Hello. Thank you for the tutorial. Yet, I don't know if it's me only, the quality of the video is very poor. I can't see what code you write. Could you possibly improve it, knowing that the objective is to REALLY help?

[@dachhisudarshan3206]

hello Dr Grande, can you also show how can we open a PPT from a userform window.. and the ppt should open in Slideshow mode

[@drm9514]

Hey, your codes are not visible. Please Zoom your your screen and then write.

[@limitone9564]

you're probably not going to answer this question bec it's been so many years since you've created this video... but just in case you want to answer, here's my question... if the document is not of .docx and it's .doc or different types of .extentions. What is the syntax to add different file extentions... I tried adding a comma and then ".doc" but it didn't work.... thanks!