Question Responses
in [Programming]
|
From: jswalsh33 on 20 Feb 2010 06:30 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
From: Mike H on 20 Feb 2010 06:38 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
From: ryguy7272 on 20 Feb 2010 13:37 Q#2, depends what version of Windows you are using. If preVista, follow these steps here: 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
|
Pages: 1 Prev: TOUGH MACRO - DARE TO CODE IT Next: Cascading Combo Boxes - Sample Working Code |