Automatic exit? 1

[dswitzer]

I am using a .bat file to call a workbook -- it will run a macro, and then close.

The .bat file works fine and is simply:

call C:\test.xls

In the spreadsheet, I have

Private Sub Workbook_Open()
    Call macro1
    Call workbook_close
End Sub

Private Sub workbook_close()
     ActiveWorkbook.Close savechanges:=True
End Sub

Everything runs fine. The only issue I have is that after the workbook closes - the excel application still exists -- how can I close this (either from excel or the batch file)...

Thanks.

Dave

 

[HarleyQuinn]

Application.Quit

Hope this helps

HarleyQuinn
---------------------------------
The most overlooked advantage to owning a computer is that if they foul up there's no law against wacking them around a little. - Joe Martin

Get the most out of Tek-Tips, read FAQ222-2244 before posting.

 

[SkipVought]

Private Sub workbook_close()
     ActiveWorkbook.Close savechanges:=True
     application.quit
End Sub
[/code


Skip,
[sub]
[glasses]Did you hear what happened when the OO programmer lost his library?...
[b]He's now living in OBJECT poverty![/b][tongue][/sub]

 

[dswitzer]

You know - I tried that yesterday -- and I just tried it again and it did not close the app window...very odd...no errors, the code was "recognized" when I added it -- as it capitalized the code to Application.Quit It just didn't work. Is there a setting somewhere that I am missing?

The workbook closes fine but the Excel app window still is left...

Thanks.

Dave

 

[ck1999]

For some reason do you have 2 instances of excel open

ck1999

 

[dswitzer]

Good question - but no. I ran through the process again -- watching the task manager -- never more than one Excel window open...

 

[AnotherHiggins]

If the code is in the activeworkbook, and the activeworkbook is closed, it cannot continue running the code.

Use Application.Quit without first closing the WB.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[xlbo]

John. Nail. Head.

Activeworkbook.save
application.quit

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[csbTR3]

I like what xlbo wrote. Is there a way to add a 10 min timer? Run the macro then 10 min later the app saves the work and turns off .
Thanks
Craig