hwnd

How to bring window to front using the Caption/Title of the applications/Program ? The following code is used to get the Caption/Title of the application but when when Appactivate is used, it simply activates the External program but does not bring the Program's window to front or Maximize it...

Hello, I've already tried to use the Office.CommandBars class to implement popup menu with text boxes. It seems to perfectly work on Excel, but I don't actually develop the userform in Excel, but in CATIA (CAD software which comes along VBA7 64 bits). Importing the Office library doesn't seem...

I would like to be able to send data from Excel to PowerPoint with VBA. For example, I might like to populate a table in PowerPoint using data from Excel. I have code that does this, but it can be very slow. The trouble is PowerPoint seems to refresh with every change. In Excel it is possible to...

I got a code that works well in vb, but the code uses listbox hwnd. this property do not exist in vba, is there a workaround for this?

I have a code that determines if a window is open or not based on input. It works well for all other programs, but for some reason does not detect when osk.exe is running... Any ideas? I basically put anything into the msgbox in my code between the quotation marks and it will search for a...

I found the following with pretty much does what is wanted - 'Written: February 14, 2011 'Author: Leith Ross ' 'NOTE: This code should be executed within the UserForm_Activate() event. Private Declare Function GetForegroundWindow Lib "User32.dll" () As Long Private Declare Function...

Hi, I have the following code to update the icon in the taskbar for my userform below. It was great however, we have dual monitor setups and the primary monitor will show the correct icon in the task bar but all additional monitors have the usual excel icon. How can I switch all monitor taskbar...

Hello, This is the first time am trying out web scraping using VBA. with the help of WiseOwl blog i was able to write the below and am successful till macro clicks to download the file. I would required help for two things: Mainly for downloading the XLS file where i presume we need to use...

Hi This is my first time working on API for Minimizing, Maximizing Buttons on Userform and Found the below following code at https://stackoverflow.com/questions/50853247/excel-vba-userform-minimise-button Would it be possible for a command button Click to automatically minimize the userform...

Hi, I have seen this question asked before and the usual workaround is to restore the worksheet name after the sheet has been renamed.. This is often done in the Worksheet Selection Change or deactivate events as follows : Private Sub worksheet_SelectionChange(ByVal Target As Excel.Range)...

Greeting All could be using Loop to close All NotePad, Here I click "Sub KillNotepadOneByOne()" this Macro Sub till I close All notepad Thanks Private Declare PtrSafe Function FindWindow Lib "user32" Alias "FindWindowA" (ByVal lpClassName As String, ByVal lpWindowName As String) As Long...

Hi, I have copied this code from the internet and it fades in my UserForm1 when called. Form Fader: Option Explicit#If VBA7 Then Private Declare PtrSafe Function SetWindowLong Lib "user32" Alias "SetWindowLongA" _ (ByVal hWnd As LongPtr, ByVal lngWinIdx As Long, ByVal dwNewLong...

All, I would like to download a file from IE 10 in the easiest way possible when not able to know the file name exactly. (server runs script to generate file on button click) After opening IE and navigating to the web page, a predictable button is clicked. This button runs a server script...

I am doing something weird and wonderful (scrambling in the dark) and have the hwnd of a particular window. Say I have found the handle for the active window and it's a webpage. Dim myDoc as HTMLDocument set myDoc = hwnd then I can access the HTML elements on myDoc How can I make the code...