I'm creating a Purchase Order form that increments the numeric value in a cell by 1 each time the workbook is opened. The user immediately 'saves as' using this numbr as the filename. I did this using a MicrosoftExcelObject 'ThisWorkbook' with the following code:
Private Sub Workbook_Open()...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.