Problem starting Excel template from Access
Posted on 2014-09-24
I have created an Excel (2013) template with quite a bit of VBA code inside, and it works perfectly.
When I start the template with a double click, it creates a new Excel file (of type .xlsm) as expected. So far, so good.
Now I want to start the Excel template from a "switchboard" Access (2013) app, which doesn't sound hard, as I already start loads of other apps (not only Access) with that switchboard app. In the latter I tried using the 2 methods which I already use for all other apps / files:
- either VBA's Hyperlink (first define the link as <path and name of the Excel.xltm file> and then Hyperlink.Follow)
- or the Shell function like this n = Shell(<Excel.exe path and name> """<path and name of the Excel.xltm file>"""
However, when I use either of these 2 methods, the Excel template ITSELF opens, it does NOT create a new Excel file. What shall I do or modify in the above to have the Excel template to create a new Excel file ?
Thanks for help