Hi,
I have a form which I am using to update a workbook, I have a cmdbutton which adds the record and asks if the user wants to add another record. If the answer is No, the user is asked if the entry is the last entry for the week. If the answer is YES then the workbook is saved as wkbook1-date.xls. What I can't figure out is
How do I close the initial workbook and clear all the data from the worksheet if the entry is the last for the week.
Can anyone help me?
Thanks,
Mareene
This message was edited by camalita on 2002-04-30 08:59
I have a form which I am using to update a workbook, I have a cmdbutton which adds the record and asks if the user wants to add another record. If the answer is No, the user is asked if the entry is the last entry for the week. If the answer is YES then the workbook is saved as wkbook1-date.xls. What I can't figure out is
How do I close the initial workbook and clear all the data from the worksheet if the entry is the last for the week.
Can anyone help me?
Thanks,
Mareene
This message was edited by camalita on 2002-04-30 08:59