Here is what i want to do:-
1. a query runs from mainframe thru DAF i can open c:MSOFFICEOFFICEEXCEL.EXE and creates mainframe.xls file in c:data
2. i want to use a template test1.xlt which i have stored in template folder. In this template i have written a macro which goes in c:data and opens mainframe.xls file and formats it.
i am not able to open this template by using this command
c:MSOFFICEOFFICEEXCEL.EXE /test1.xlt do u know how to open this template or any other method.
Thanks
1. a query runs from mainframe thru DAF i can open c:MSOFFICEOFFICEEXCEL.EXE and creates mainframe.xls file in c:data
2. i want to use a template test1.xlt which i have stored in template folder. In this template i have written a macro which goes in c:data and opens mainframe.xls file and formats it.
i am not able to open this template by using this command
c:MSOFFICEOFFICEEXCEL.EXE /test1.xlt do u know how to open this template or any other method.
Thanks