I'm running a VBA code on an external application from excel. Now after clicking on 'export to excel' button on that application, the data is exported to a new workbook in a new excel application.
Please let me know how to get control over the new excel application or workbook.
I agree that through VBA you could get all the running prosses and check if it is excel but that is it.
But using the windows api you could do this and get the handle to each excel. Then get your object
Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…