ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Template Purchase Order (https://www.excelbanter.com/excel-discussion-misc-queries/10206-template-purchase-order.html)

br6

Template Purchase Order
 
How do you set up database to capture the Purchase order number?
Can the numbering system be set up so that it is unique?
Thanks

Mark

hi,
it depends on the template. if you use an Auto_open ()
macro that sets the number you can record that number in a
text file or another workbook. Better a text file so that
that file does not need to be open like a workbook. Look
up WriteLine in msdn help

- mark


-----Original Message-----
How do you set up database to capture the Purchase order

number?
Can the numbering system be set up so that it is unique?
Thanks
.



All times are GMT +1. The time now is 10:18 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com