VBA Invoice Open New Window
If you make your template file an Excel Template, Excel
will handle this for you. Just click File/SaveAs on the Menu. Change the file type to Template and save. When Excel opens this file, it creates a file with name YourFileName1.xls where the template file name was YourFileName.xlt. Hope that helps! -----Original Message----- I have a big excel vba project that creates an invoice it was an intial template sheet, copies that to a new sheet, then fills in the new sheet with data. All of this is front ended with forms and the application is hidden. At the click of a button on the form, I want the form to disappear, the newly created invoice in a new window so that the user cant ruin the template file, and then onclose of the new window, display the form again. Can someone please guide me in the right direction. Thanks! -- jocooper69 ---------------------------------------------------------- -------------- jocooper69's Profile: http://www.excelforum.com/member.php? action=getinfo&userid=15129 View this thread: http://www.excelforum.com/showthread...hreadid=267621 . |
All times are GMT +1. The time now is 06:05 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com