tcarnahan
02-11-2015, 12:06 PM
I just moved from MS-Office 2010 to MS-Office 2013. I had several sections of VBA code that I used successfully before that no longer work. The VBA code is in my MS-Access application and is used to manipulate MS-Excel.
[*=1]Detect Excel: a call to the DLL that checked if Excel was already running. If it was running, then it would add the new instance to the "running list". If it was not running, it would start up a new instance
[*=1]Bring Excel Window to the Foreground: a call to the DLL that identified the Excel window and brought it into focus in the foreground.
Since going to 2013, these no longer work. There is some information out on the web about converting over some DLL calls but it is not clear how to perform the two functions above.
Question: can anyone point me to some clear documentation of the correct substitute code to call the DLL and perform those two functions in the MS-Office 2013 environment?
Thanks,
Tom
[*=1]Detect Excel: a call to the DLL that checked if Excel was already running. If it was running, then it would add the new instance to the "running list". If it was not running, it would start up a new instance
[*=1]Bring Excel Window to the Foreground: a call to the DLL that identified the Excel window and brought it into focus in the foreground.
Since going to 2013, these no longer work. There is some information out on the web about converting over some DLL calls but it is not clear how to perform the two functions above.
Question: can anyone point me to some clear documentation of the correct substitute code to call the DLL and perform those two functions in the MS-Office 2013 environment?
Thanks,
Tom