Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question Responses
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question Responses
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. "jswalsh33" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Question Responses
Q#2, depends what version of Windows you are using. If preVista, follow
these steps he http://www.iopus.com/guides/winscheduler.htm -- Ryan--- If this information was helpful, please indicate this by clicking ''Yes''. "Mike H" wrote: 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. "jswalsh33" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question re conditional responses | Excel Worksheet Functions | |||
I hope to get many responses on this. | Excel Programming | |||
counting responses | Excel Programming | |||
no responses... | Excel Discussion (Misc queries) | |||
counting responses - please help | Excel Worksheet Functions |