Excel Automation

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Dave

    Excel Automation

    Hey. Anyone got a hint for me ?
    My app picks-up the currently running instance of Excel, and exports data to
    it via automation. Works fine, except if I close and then reopen Excel while
    my app is running... doesn't pick it up anymore...

    The responsible code is:

    Dim NewxlApp As Excel.Applicati on
    NewxlApp = GetObject(, "Excel.Applicat ion")

    Would appreciate help dearly! Thanks,
    Dave

Working...