We have couple of excel VBA templates with forms, which we had been using through company intranet and it works fine. Now we plan to give the access to same templates through our website. We found while testing that VBA templates open when we hit open button (while trying from web) rather than running from the web.
In other words i mean that these templates are in xlt format and we want when user uses them it opens in xls format. But when we try to use them from web..they open as xlt. One way is to somehow tell users to save it on their H/D and then use.
Could anyone suggest anyother better way? Is their a way that when user tries to open through net it runs(xls) rather than opening(xlt) ? Or is their a way that while putting them on net we could disable the open button.
Suggestions will be highly appreciated.
In other words i mean that these templates are in xlt format and we want when user uses them it opens in xls format. But when we try to use them from web..they open as xlt. One way is to somehow tell users to save it on their H/D and then use.
Could anyone suggest anyother better way? Is their a way that when user tries to open through net it runs(xls) rather than opening(xlt) ? Or is their a way that while putting them on net we could disable the open button.
Suggestions will be highly appreciated.
