Malcolm torishi
Board Regular
- Joined
- Apr 26, 2013
- Messages
- 219
Hi
I have two workbooks the first named "number" which just contains the number 50000 on sheet 1 cell A1. This "number" workbook is always closed and saved in c:\me\"number". The second named "sales" has a form control button with code as follows and is always opened and saved in c:\me\
Sub next invoice()
range ("A1"). Value= range ("A1"). value+1
End sub
When I press the button this code does not work because I am missing the vba code to find the close file can any one help please. Thank you
I have two workbooks the first named "number" which just contains the number 50000 on sheet 1 cell A1. This "number" workbook is always closed and saved in c:\me\"number". The second named "sales" has a form control button with code as follows and is always opened and saved in c:\me\
Sub next invoice()
range ("A1"). Value= range ("A1"). value+1
End sub
When I press the button this code does not work because I am missing the vba code to find the close file can any one help please. Thank you