Project 1 - vb macro update #2

u587162
u587162 used Ask the Experts™
on
Hi

I need the template attached by Wiesjs amended please so that the macro automatically saves the newly generated template in the *.xls format rather than *.xlsx format (even though the file name is *.xls).

Link is http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_27727135.html


Thanks.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
This works, thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial