VBA for Insert Object >>Create from File>>Choose File. In Word Document

Hello,

I am attempting to create a VBA to simply Insert an Excel worksheet into a word document. I use the insert Object>>Create from File>>Choose File. I use this method because it provides a much clearer picture in the word document. I know how to write a VBA to simply copy and paste the Excel Data in to a Word document, so please don't suggest that method. If anyone has an idea how to write a VBA for this application that would be great.

F.Y.I. I am running a office 2013 system.

Thank you.

Jeff,

Thank you fro the response, when I run the Macro I get a error. Run-time error'5': Invalid procedure call or argument. When I open up the macro it highlights the openDialog.Filters.Add "Excel workbooks", " **.xlsm"
If you have any suggestions that would be great.

Thank you,
KT

That works perfect, Thank you. One more quick question, If I Want to open a specific file can I just enter that file name in, instead of "*.xlsm"?

thank you,
KT

That works out great! thank you for all your help.

Jeff,
You have been a lot of help so far in this process, I was wondering if you know the VBA code to have the inserted object fit to the word document page. If so that would be awesome.

Thank you,
KT