running excel in background

  • Thread starter Thread starter Don
  • Start date Start date
D

Don

I'd like to run a program that writes values from one
cell to another with a VBA program that is triggered by
the clock. I've completed this part but, since I use
active cells, you can't run another workbook without the
clock activating the cell in the active worksheet. It
needs to run in the background all day long. - ideas?
will it run in the background if I don't activate cells?
 
I have a similar problem:
I need to run Excel macro while working on something else. The macr
execution stops if Excel is not activated, which a second instance o
Excel doesn't solve.
Any ideas?
Thanks
 
Macro execution should continue while Excel doesn't have focus. It doesn't
hurt to put DoEvents somewhere in the loop.
 
Back
Top