I should add that Application.Top, Application.Left etc don't work for this external window. It is a big ask, but if anyone has a spare hour it would be a huge help, as I am blocked from completing my macro and can't get my head around this topic at all. I need this for 64bit and 32bit API libraries, as it will be used on different versions of excel (i.e. Windows API Calls 255 In the Programming with the Windows API chapter of our Excel 2002 VBA Programmers Reference, we approached the subject of using Windows API calls by explaining how to locate the denitions for various functions on the MSDN Web site and translate those functions for use in VBA. (I will need help on that too eventually I guess
Incidentally most keyboard shortcuts cannot be used in it either which is the reason for this, so i can simulate mouse clicks instead once i set the location of the window. I am looking for a copy and paste solution to move a stubborn window by VBA, that opens exactly in the center of the screen irrespective of the resolution, and maximising and sizing is disabled on it. Can anyone provide me with the code required to find the screen co-ordinates of any window, searchable by its window name as it would appear in appActivate() for example? I know nothing about using APIs to find windows, nor handles etc., and the numerous threads I have read make no sense to me.
0 kommentar(er)
