win32

Hi Does anyone have any experience in using the UXTheme.dll visual styles to create 'modern' looking controls in the VBA Userform? I've been experimenting with it, and I've hit a wall of sorts - especially when it comes to the Textbox. I would be grateful for any guidance or recommended...

WIth the help of Jaafar, I'm trying to learn how to use the DispCallFunc API with 64 bit API. I have been trying to work my way through the examples at the following tutorial: Windows API DispCallFunc as function pointer in VBA And managed to get the following working: Private Declare PtrSafe...

I set out below my research re: WinRT APIs. These are separate to the Win32 API set and allow access to greater windows functionality. I first came across them from the PowerToys Image2Text OCR tool, which was then implemented by the AHK community here: Easy OCR - AutoHotkey Community From...

Hi The code below is meant to retrieve the username in a cell with the formula =fOSUserName() The code works flawlessly on my private desktop with Excel 2019 64 bit. However, the code does not seem to work on my company's desktop with Excel 2016 32 bit, even though the code works on this 32...

Hi all, Hi Jaafar ;) I am working on a tool manipulating the VBProject of other Excel files, which can have their VBProject locked with 2 different passwords. But I have no way to know which one it will be in advanced, so I must attempt them one after the other. I managed to write some code...

My macro runs fine until I turn on power-query. Once this is turned on I get an error message. How can I run the macro error free with power-query turned on? Win7/64+Office2013/32 Error Message: " See the end of this message for details on invoking just-in-time (JIT) debugging instead of...

I am receiving an unhandled win32 exeption [256] when I execute my code. When I walk through the debugger line-by-line, I do not receive the error! It also goes away when I comment out two specific lines. These lines update the progress bar on a userform shown at the end of the loop. Very...