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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment