Question Responses

  • Thread starter Thread starter jswalsh33
  • Start date Start date
J

jswalsh33

Two Questions:

1. I have a program that is intended to run unattended. It runs, collects
data and then closes all open workbooks. However, when it closes a workbook
it asks "Do you want to save changes?". That requires an operator input. How
do I avoid getting the question?

2. To start the process unattended I have to be in Excel. If my computer is
on but Excel is not running, how do I get Excel open?

Thanks for your help.

Jim Walsh
 
Hi,

Q1.

When you close the workbook use something along the lines of

ActiveWorkbook.Close savechanges:=False

or it it isn't the active workbook

Workbooks("Book2.xlsx").Close savechanges:=False

Q2. Is a Wndows question and you can do it with task scheduler. You may get
more help on that here or maybe in a Windows forum
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
Back
Top