I want my excel file to automatically close when it reach 4 hours from the time it is opened. Please help.?

0 ⤊

I want my excel file to automatically close when it reach 4 hours from the time it is opened. Please help.?

When my excel file reach 4 hours from the time it is opened, I want it to automatically close. What should be the macro command. Thanks for helping me.

2006-06-20 01:53:00 · 4 answers · asked by nelson_maus 2 in Computers & Internet ➔ Programming & Design

4 answers

Look up Application.OnTime() in the help.

2006-06-20 06:44:57 · answer #1 · answered by stjnky 3 · 0⤊ 0⤋

create a form in vb Editor and a timer in. set the interval to hour * 3600.

2006-06-20 09:20:27 · answer #2 · answered by Morris 2 · 0⤊ 0⤋

ActiveWindow.Close

2006-06-20 09:05:25 · answer #3 · answered by AnalProgrammer 7 · 0⤊ 0⤋

True

You can use what "StriderThe1" technique and type in what "AnalProgrammer" suggest and you are done

Try it it worth to try

XLMan

2006-06-21 04:16:58 · answer #4 · answered by Anonymous · 0⤊ 0⤋