Open Excel Template from Access Command

I want to be able to open an Excel Template (.xltx) as a workbook (.xlsx) from an Access macro. I have another database that does this, but I couldn't copy the command. I'm running Access 2010, and I think that maybe the original command was done in version 2007.

So my example is this:
Submacro: LenderForm
RunApplication: excel.exe /t "PathToFormGoesHere.xltx"

My problem is that the option for "RunApplication" seems to be missing from my macros in Access 2010. Is there another solution to acheive the same goal?

I'm not a VBA wiz, I aspire to reach novice level on a good day, so I'll request a little hand-holding upfront if that's the only solution. Thanks for your help!

Originally Posted by acmagyar

My problem is that the option for "RunApplication" seems to be missing from my macros in Access 2010. Is there another solution to acheive the same goal?

I'm not a VBA wiz, I aspire to reach novice level on a good day, so I'll request a little hand-holding upfront if that's the only solution. Thanks for your help!

RunApplication still exists in Access 2010, but you must click "Show All Actions" on the ribbon in the create macro screen to see the command. Although most of the time VBA is preferred, and if I were you I would try to learn how to implement what the other person posted.

@maw230 - Thank you for helping me find the simple solution! I feel ridiculous that I forgot about "Show All Actions."

I also acknowledge that I need to seek VBA training, easier said than accomplished though! I was trying to implement alansidman's response when I saw the easier solution come through. Thanks so much for the prompt answers!