Check Instance of Excel
Posted on 2006-05-10
I have a function that checks wether an instance of excel is already open, this works fine, but I am using the code:
if there is no instance then I use "Set appxl = New Excel.Application"
if there is an existing instance then I use "Set appxl = Excel.Application"
But both bits of code open a new instance, why? Any ideas/alternatives so the code will work to open a workbook in an existing instance?