Can someone plz help? Run MS Teams Application in the background_Click and Minimize

[NametobeRenamed]

Hello All,


Is it possible to run MS Teams in the background (just click the application and minimize the MS Teams window afterwards). And I want this clicking and then minimizing of Teams window to happen every 5 mins.

On my screen there could be other active windows OPEN and this (Macro's) shouldn't interfere with applications which are open currently. Is this possible using VBA coding?
If this is possible, can Macro run automatically as soon as I open the excel? Thank you all in advance!!


P.S: For other who don't know what is MS Teams this is just another Microsoft Application and same as Skype.

I tried to an extent but failed, please check the my code below

Please Login or Register  to view this content.

Please Login or Register  to view this content.

When I first executed the code, the MS Teams window is getting clicked. But I see 2 problems
1. When I run this script for 10 times then out of 10 only 2-3 times the MS Teams window is getting opened (I mean maximizing)
2. And all these10 times, the MS Teams Window is NOT getting minimized (I think this line ... ‘Application.WindowState = xlMinimized ‘ .. is not working in the code)

And the second code, Run Macro Every 5 mins, I don't think this is working at all.

Can these two get fixed?
Plus I want these two scripts get executed as soon as I open the excel file.Thank you in advance!!