Windows API in VBA - Strings (Part 2) - Unicode vs. ANSI

[@bounsanongvongphachanh823]

You are helping people around the world that struck on this message box with thier language popup not correctry including me, you are professional vba, thanks alots.......

[@又大又黑又粗又久]

I'm so appreciated that your video series that how to call api in vba, Respectly!!!!

[@bluxer4225]

99% of VBA content on youtube is Excel-oriented. So, this VBA Access channel is mostly unique. (personally i'm a Word guy :))

[@codekabinettcomen]

Thank you! For the Win-API-Series I would like to stress it is completely agnostic of the host application and you can use all this in Word, Excel, and Outlook all the same.

[@martinleduc]

Thanks! I really appreciate the explanations on "Why" things work this way.

[@fengqingchu8399]

Hi,Nice to see you again.Your Windows Api contents are of vital importance for VBA developers to step into the next hight level!

[@Dyxacm]

Respect for your position and for useful lessons aswell! 👍

[@peterwooldridge7285]

That was really exciting, like reading mystery novels...great and Informative

[@codekabinettcomen]

Thank you very much!

[@giuseppefruci4383]

Good video, unravelling the mysteries of the API is a always a challenge.

[@codekabinettcomen]

There are more mysteries to come. :)

[@xavierbatlle1828]

Thanks! Very interesting and useful.

[@RICARDOHERNANDEZ-rf3ug]

A very clear explanation, it was what I was looking for, thank you very much

[@murtazaibrahim6560]

Good research mate. Your video topics are unique and indeed learn something new.

[@redhaakhund1271]

Excellent top👍👍👍👍👍🙏

[@omidmehdi]

Very useful video Please complete this playlist about this conviloluted Winapi that we see from time to time in vba Beste Grüße

[@codekabinettcomen]

Thank you. I'll try to pick up this series.

[@Alexey0795]

2:37 Нет войнЫ => Нет войнЕ how would I translate it: there is no war => (say) No to war

[@عليعلي-ن1خ3ص]

Nice video ! Question: Since Strings in the vba runtime are unicode, why does the VBA standard MsgBox (which is part the vba runtime) always displays ANSI characters ?

[@ericturner5154]

Hey! Where’s did u go? Hope all is ok…

[@codekabinettcomen]

Thank you for asking. I'm fine but I'm dealing with some issue and currently neither have time nor motivation doing new videos. - I'll be back.

[@thomas.a.lassen]

In my team we are trying to put together VBA code that communicates with an application via the Windows SendMesage-api. But we are having trouble sending a message back to the VBA code. Do you have any reference on achieving something like this?

[@codekabinettcomen]

Use a different way of communicating with that app if you can. If you can't, you must overwrite the WindowProc of one of your Access windows to process the messages sent to that window. It's possible but has unpleasant side effects... Keyword: Subclassing (I've got this on my list for future videos, but don't hold your breath for it to arrive.) Alternatively, create a COM DLL that handles the communication and then add this DLL as a reference to your VBA project.

[@legionssssss3865]

Hi there, thanks for the informative tutorial. I currently have an VBA code to save a file to .txt FileFormat: xlUnicodeText Is there a line of code I can add to change the encoding from "Unicode" to "ANSI"?

[@codekabinettcomen]

The XlFileFormat enumeration has several options for non-unicode text. I suggest you check out the documentation if any of those solves your problem.

[@tommik1283]

Not only this unicode thing shows how little MS cares about Office VBA in modern times and it is not likely to get better. Yet another pain is the "usage" of VBA calling API functions in 64 bit Windows - for example try to call external process and get its stdout straight into VBA variable. Something that is quite trivial in .NET VB, practically impossible in VBA...

[@thomasfergusen5144]

Hello, i have a question: "thisworkbook.save" code takes alot of time (even i did "Application.CalculateBeforeSave = False" and "Application.Calculation = xlCalculationManual") so i decided to use that code only in "Private Sub Workbook_BeforeClose(Cancel As Boolean)" subroutine. But the problem is when electric is off or somehow programme get a runtime error vba does not read the code. ( i dont want to get recovery offering because of users not familiar that) so what to do? Thanks!

[@codekabinettcomen]

Sorry, I don't fully understand the problem. It seems to complex to be answered in a short comment here.