Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How I can I open a small window within window | Excel Discussion (Misc queries) | |||
OPen an DOS WIndow | Excel Discussion (Misc queries) | |||
WHAT IS THE PROCEDURE TO CHANGE CURENCY IN THE INVOICE WINDOW | Excel Discussion (Misc queries) | |||
open new window | Excel Discussion (Misc queries) | |||
Excel workbook does not open in open window on desktop | Excel Discussion (Misc queries) |