Sunday, August 2, 2009

How do i create an excel macro language with visual basic to exit the program?

i know how to get to visual basic when editing a macro with code in visual basic, or along the lines of that anyway, i just can't remember what the piece of code was. i have to do this command to pass my assignment and it's the last thing i need to do and its due in tomorrow so all help is much appreciated as quickly as possible please?


thanks to all in advanced


marky j

How do i create an excel macro language with visual basic to exit the program?
Assume you have only 1 workbook open


Sub closeExcel()


      Application.Quit


      ThisWorkbook.Saved = True


      Exit Sub


End Sub


Hope this helps.
Reply:One I have starts with Sub Macro1 () and ends with Exit Sub - before exit there is a Application.Goto Reference:="R21C1" where calculated results start.
Reply:the command you need to put in your macro is





application.exit

song meanings

No comments:

Post a Comment