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

[mirandat]

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!

[zureezee]

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

[anahgalloway]

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.

[happymm]

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!

[jassrana]

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 from excel.

Can you help please

[gusTechnikPro]

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

[limitone]

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!

[lmt]

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

[asaqarbeh]

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

[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?

[tongapo]

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?

[drm]

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

[dachhisudarshan]

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