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_Debits\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
> > >
Similar Threads
