Is there a method by which we can programatically save the workbook?
Like workbook.close closes the workbook,I couldn't find
workbook.save.Is there a way to do.
Actually therz a variable suppose y, if its 1 then next time the user
opens the workbook therz a form which should'nt be displayed.So what I
did is copied the value of y into one of the worksheet and cheking
this cell value in the workbook_open event .if not 1 then dispalys the
form.But problem arises when user inputs Y as 1 and closes the book
without saving.The value of y is not saved in the book,so next time
form opens when he opens the workbook.
My problem can be solved either of two cases

1.therz a way to force the workbook to save immediately after taking
the input value for y,programatically.
2.A way to find that workbook is opened for the first time.

Kindly suggest a way

Regards