Opening Word template: Path

[MWXA]

Greetings!

When opening a Word 2010 document using VBA in Excel 2010, do I need to type the entire path. For example, I am using a template as follows

Please Login or Register  to view this content.

If I want to transfer this workbook to a different computer, or would like to allow another user to use the workbook VBA code, I would like an easier way to have the code find the document template without having to re-write the code each time. Can this be accomplished?

Thanks

[abousetta]

Hi,

You can use the Application.GetOpenFilename function to manually pick the template or if it will always be in a folder on the desktop named Project then you can use WScript

Please Login or Register  to view this content.

[MWXA]

Thanks you, abousetta. Worked perfectly.