Results 1 to 4 of 4

Thread: [RESOLVED] Strange behavior - background Excel

Threaded View

  1. Feb 21st, 2012, 02:15 PM #1
    VBAhack
    VBAhack is offline

    Thread Starter
    Fanatic Member VBAhack's Avatar
    Join Date
    Dec 2004
    Location
    Sector 000
    Posts
    617

    Resolved [RESOLVED] Strange behavior - background Excel

    I have a vbscript file that launches Excel in the background, opens a workbook and executes a macro (takes 1hr to execute the macro).

    While the background instance of Excel is running, if I open a different workbook in the foreground by double clicking the file name, for some reason the workbook in the background instance of Excel becomes visible and the vbscript aborts.

    I can get around this with a two-step process by launching Excel (via shortcut) then opening the desired workbook, but why would this be needed?

    I don't understand why opening a (different) workbook in the foreground would mess up a background instance of Excel.

    Comments?
    Last edited by VBAhack; Feb 21st, 2012 at 04:03 PM.
    VBAhack
    (Links: Cubic Spline Tutorial, Parametric Cubic Spline Tutorial, VB Numerical Routines    )

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width