Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Macro and Locked PC
I created a auto run macro in Excel using VBA. An access database kicks off
via windows scheduler and creates data files needed by excel. Once the files have been created, before access closes, it opens the excel spreadsheet where the auto run macro is stored. This process is set for early in the morning, but it seems to stall or "pause" after excel starts. Once I unlock the machine, the macro "unpauses". Is this an excel issue? Is their code to prevent this from happening? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Macro and Locked PC
Does your machine require you to sign on with a password? I built an auto
scheduler and found that newer (2003+) versions of windows require that a password be set on the machine, or the machine has to be unlocked to run a scheduled task. Someone else might have more info on the subject. -- -John Please rate when your question is answered to help us and others know what is helpful. "Vinny P" wrote: I created a auto run macro in Excel using VBA. An access database kicks off via windows scheduler and creates data files needed by excel. Once the files have been created, before access closes, it opens the excel spreadsheet where the auto run macro is stored. This process is set for early in the morning, but it seems to stall or "pause" after excel starts. Once I unlock the machine, the macro "unpauses". Is this an excel issue? Is their code to prevent this from happening? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Macro and Locked PC
Yes, however, windows scheduler works fine. My User name and pw is stored.
The scheduler kicks of the access macro first and access calls excel. Its when the excel macro begins, the code appears to be stuck ONLY when the pc is in a locked state. "John Bundy" wrote: Does your machine require you to sign on with a password? I built an auto scheduler and found that newer (2003+) versions of windows require that a password be set on the machine, or the machine has to be unlocked to run a scheduled task. Someone else might have more info on the subject. -- -John Please rate when your question is answered to help us and others know what is helpful. "Vinny P" wrote: I created a auto run macro in Excel using VBA. An access database kicks off via windows scheduler and creates data files needed by excel. Once the files have been created, before access closes, it opens the excel spreadsheet where the auto run macro is stored. This process is set for early in the morning, but it seems to stall or "pause" after excel starts. Once I unlock the machine, the macro "unpauses". Is this an excel issue? Is their code to prevent this from happening? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Macro and Locked PC
Could excel be waiting for a user to allow macros to run?
Could your code be waiting for a user to dismiss a msgbox? Vinny P wrote: Yes, however, windows scheduler works fine. My User name and pw is stored. The scheduler kicks of the access macro first and access calls excel. Its when the excel macro begins, the code appears to be stuck ONLY when the pc is in a locked state. "John Bundy" wrote: Does your machine require you to sign on with a password? I built an auto scheduler and found that newer (2003+) versions of windows require that a password be set on the machine, or the machine has to be unlocked to run a scheduled task. Someone else might have more info on the subject. -- -John Please rate when your question is answered to help us and others know what is helpful. "Vinny P" wrote: I created a auto run macro in Excel using VBA. An access database kicks off via windows scheduler and creates data files needed by excel. Once the files have been created, before access closes, it opens the excel spreadsheet where the auto run macro is stored. This process is set for early in the morning, but it seems to stall or "pause" after excel starts. Once I unlock the machine, the macro "unpauses". Is this an excel issue? Is their code to prevent this from happening? -- Dave Peterson |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Macro and Locked PC
Thats what it seems like, but the macro does not require user input. No
message boxes. Perhaps it is something in my code preventing excel from running while locked? "Dave Peterson" wrote: Could excel be waiting for a user to allow macros to run? Could your code be waiting for a user to dismiss a msgbox? Vinny P wrote: Yes, however, windows scheduler works fine. My User name and pw is stored. The scheduler kicks of the access macro first and access calls excel. Its when the excel macro begins, the code appears to be stuck ONLY when the pc is in a locked state. "John Bundy" wrote: Does your machine require you to sign on with a password? I built an auto scheduler and found that newer (2003+) versions of windows require that a password be set on the machine, or the machine has to be unlocked to run a scheduled task. Someone else might have more info on the subject. -- -John Please rate when your question is answered to help us and others know what is helpful. "Vinny P" wrote: I created a auto run macro in Excel using VBA. An access database kicks off via windows scheduler and creates data files needed by excel. Once the files have been created, before access closes, it opens the excel spreadsheet where the auto run macro is stored. This process is set for early in the morning, but it seems to stall or "pause" after excel starts. Once I unlock the machine, the macro "unpauses". Is this an excel issue? Is their code to prevent this from happening? -- Dave Peterson |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Macro and Locked PC
If it is waiting for someone to approve macro's as Dave suggested, you can
get a certificate such as selfcert (the one i use, free) and you can digitally sign your work, once accepted, the accept macro box no longer shows up. -- -John Please rate when your question is answered to help us and others know what is helpful. "Vinny P" wrote: Thats what it seems like, but the macro does not require user input. No message boxes. Perhaps it is something in my code preventing excel from running while locked? "Dave Peterson" wrote: Could excel be waiting for a user to allow macros to run? Could your code be waiting for a user to dismiss a msgbox? Vinny P wrote: Yes, however, windows scheduler works fine. My User name and pw is stored. The scheduler kicks of the access macro first and access calls excel. Its when the excel macro begins, the code appears to be stuck ONLY when the pc is in a locked state. "John Bundy" wrote: Does your machine require you to sign on with a password? I built an auto scheduler and found that newer (2003+) versions of windows require that a password be set on the machine, or the machine has to be unlocked to run a scheduled task. Someone else might have more info on the subject. -- -John Please rate when your question is answered to help us and others know what is helpful. "Vinny P" wrote: I created a auto run macro in Excel using VBA. An access database kicks off via windows scheduler and creates data files needed by excel. Once the files have been created, before access closes, it opens the excel spreadsheet where the auto run macro is stored. This process is set for early in the morning, but it seems to stall or "pause" after excel starts. Once I unlock the machine, the macro "unpauses". Is this an excel issue? Is their code to prevent this from happening? -- Dave Peterson |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Macro and Locked PC
Or change the security level to the lowest choice to allow every macro to run.
MS doesn't recommend this. Vinny P wrote: Thats what it seems like, but the macro does not require user input. No message boxes. Perhaps it is something in my code preventing excel from running while locked? "Dave Peterson" wrote: Could excel be waiting for a user to allow macros to run? Could your code be waiting for a user to dismiss a msgbox? Vinny P wrote: Yes, however, windows scheduler works fine. My User name and pw is stored. The scheduler kicks of the access macro first and access calls excel. Its when the excel macro begins, the code appears to be stuck ONLY when the pc is in a locked state. "John Bundy" wrote: Does your machine require you to sign on with a password? I built an auto scheduler and found that newer (2003+) versions of windows require that a password be set on the machine, or the machine has to be unlocked to run a scheduled task. Someone else might have more info on the subject. -- -John Please rate when your question is answered to help us and others know what is helpful. "Vinny P" wrote: I created a auto run macro in Excel using VBA. An access database kicks off via windows scheduler and creates data files needed by excel. Once the files have been created, before access closes, it opens the excel spreadsheet where the auto run macro is stored. This process is set for early in the morning, but it seems to stall or "pause" after excel starts. Once I unlock the machine, the macro "unpauses". Is this an excel issue? Is their code to prevent this from happening? -- Dave Peterson -- Dave Peterson |
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Macro and Locked PC
I installed the digital cert, but still experiencing the same issue.
Here is the line in the access macro that triggers excel.. ' Open Excel Cash-Two_Auto.xls Call Shell("""C:\Program Files\Microsoft Office 2003\OFFICE11\EXCEL.exe"" ""\\fiscmmk204win\common\nfs\dmn6\users\margin\U_D ebits\Macros\cash-two_auto.xls""", 1) Once excel launches, I created a Workbook_Open Macro the first line calls a sub function. I am not sure if the macro is pausing at workbook_open or the first call. WorkBook_Open macro.. Private Sub Workbook_Open() ' Shut off Warning Messages Application.DisplayAlerts = False ' Run Cash Due Items for Retail Call CASHdueTWO Here is a few lines from "Call CashDueTwo" AppActivate "MICROSOFT EXCEL" Workbooks.OpenText Filename:="G:\apps\DOWNLOAD\MARGIN\CES.TXT", Origin _ :=xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array _ (0, 2), Array(3, 2), Array(9, 9), Array(10, 1), Array(26, 9), Array(27, 1), Array(43, 3)) Workbooks.OpenText Filename:="G:\apps\DOWNLOAD\MARGIN\SBI.TXT", Origin _ :=xlWindows, StartRow:=1, DataType:=xlFixedWidth, FieldInfo:=Array(Array _ (0, 2), Array(3, 2), Array(9, 9), Array(10, 1), Array(26, 9), Array(27, 1), Array(43, 3)) Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Windows("CES.TXT").Activate Columns("A:A").Select SendKeys "^{end}", True SendKeys "{home}", True SendKeys "{down 2}", True Windows("SBI.TXT").Activate Selection.Copy "John Bundy" wrote: If it is waiting for someone to approve macro's as Dave suggested, you can get a certificate such as selfcert (the one i use, free) and you can digitally sign your work, once accepted, the accept macro box no longer shows up. -- -John Please rate when your question is answered to help us and others know what is helpful. "Vinny P" wrote: Thats what it seems like, but the macro does not require user input. No message boxes. Perhaps it is something in my code preventing excel from running while locked? "Dave Peterson" wrote: Could excel be waiting for a user to allow macros to run? Could your code be waiting for a user to dismiss a msgbox? Vinny P wrote: Yes, however, windows scheduler works fine. My User name and pw is stored. The scheduler kicks of the access macro first and access calls excel. Its when the excel macro begins, the code appears to be stuck ONLY when the pc is in a locked state. "John Bundy" wrote: Does your machine require you to sign on with a password? I built an auto scheduler and found that newer (2003+) versions of windows require that a password be set on the machine, or the machine has to be unlocked to run a scheduled task. Someone else might have more info on the subject. -- -John Please rate when your question is answered to help us and others know what is helpful. "Vinny P" wrote: I created a auto run macro in Excel using VBA. An access database kicks off via windows scheduler and creates data files needed by excel. Once the files have been created, before access closes, it opens the excel spreadsheet where the auto run macro is stored. This process is set for early in the morning, but it seems to stall or "pause" after excel starts. Once I unlock the machine, the macro "unpauses". Is this an excel issue? Is their code to prevent this from happening? -- Dave Peterson |
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Auto Macro and Locked PC
My apologies everyone. Please forgive my ignorance. I was using a macro created by a previous manager. I realized after evaluating each step where the bottleneck was. The macro was pausing at the SendKeys command. I smply replaced the commands and the macro ran with no issues. Thanks again for all your help. At least I walked away not only learning how to dissect a macro line for line, I also understand the use of digital certs. Thanks again. "Dave Peterson" wrote: Or change the security level to the lowest choice to allow every macro to run. MS doesn't recommend this. Vinny P wrote: Thats what it seems like, but the macro does not require user input. No message boxes. Perhaps it is something in my code preventing excel from running while locked? "Dave Peterson" wrote: Could excel be waiting for a user to allow macros to run? Could your code be waiting for a user to dismiss a msgbox? Vinny P wrote: Yes, however, windows scheduler works fine. My User name and pw is stored. The scheduler kicks of the access macro first and access calls excel. Its when the excel macro begins, the code appears to be stuck ONLY when the pc is in a locked state. "John Bundy" wrote: Does your machine require you to sign on with a password? I built an auto scheduler and found that newer (2003+) versions of windows require that a password be set on the machine, or the machine has to be unlocked to run a scheduled task. Someone else might have more info on the subject. -- -John Please rate when your question is answered to help us and others know what is helpful. "Vinny P" wrote: I created a auto run macro in Excel using VBA. An access database kicks off via windows scheduler and creates data files needed by excel. Once the files have been created, before access closes, it opens the excel spreadsheet where the auto run macro is stored. This process is set for early in the morning, but it seems to stall or "pause" after excel starts. Once I unlock the machine, the macro "unpauses". Is this an excel issue? Is their code to prevent this from happening? -- Dave Peterson -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Locked worksheet & hyperlinks (w/ select locked cells unchecked) | Excel Discussion (Misc queries) | |||
Auto Fill with some references locked | Excel Discussion (Misc queries) | |||
run a macro in a locked cell | Excel Discussion (Misc queries) | |||
Locked Macro Project | Excel Discussion (Misc queries) | |||
Macro - Playing Macro if cells are locked | Excel Programming |