Search:
Type: Posts; User: sancarn
Search:
Search took 0.02 seconds.
-
To be fair, it isn't always a choice.
-
Hi MountainMan
Would be worth posting the code. Benchmarks without code aren't great because you can never tell if the implementor had an alterior motive, not saying you do :p
I must say I'm...
-
@xiaoyao are you trying to use CDP? I hear that usage of pipes is the better approach than websocket. Unfortunately my library is still very under developed. Indeed you have ran into the same issue...
-
Excuse my ignorance but I assumed `DispCallFunc` would be able to do that...
But if not I guess the only option is loading a DLL into the external process right? Sucks...
-
Yeah both processes are VB6/VBA though? So which process does it get the ebmode for? I.E. is the ebmode function relative to the application it's loaded into, or relative to the application executing...
-
Trick, thanks so much for this class. I'm intrigued by your usage of EbMode. I'm currently working on a project where it would be very useful to identify the EbMode of another VBA application. If I...
-
Damn clever and simple solution there Elroy! Would suggest heavily documenting that the array is unsorted if this is what you are doing though.
-
Mad this feels like something I should have known. Thanks for the info :)
-
I was browsing some source code and read the following quote:
From my experience with UDTs and CopyMemory I'd think that VBA structs are always contigious in memory. Either I don't understand...
-
That's totally fine Elroy, no one asked you (specifically) to contribute. Your thread will be a good basis though, even if VBA is changed. You're right, of course, that there are no guarantees, but...
-
Indeed
No there isn't? The thunk variant is wqweto's This on the other hand uses no thunk as far as I can see?
Yes, this if you look at my sample is dealt with I believe, which is the...
-
Struggling to get this working in 64 bit... I'm probably missing something, but wondered whether anyone had any idea what?
'Routine is basically an AddressOf function for VB code pages...
-
This. I love VB6/VBA, but I have to agree with this. Other mistakes in my opinion:
Lack of lambda expressions
Lack of low-level object pointers (even if the pointer was to a slug...
-
Yes, unfortunately, for both parties. A nightmare for users because they are left to maintain applications in archaic programming languages like VBA. And a nightmare for IT because Mike from...
-
Can confirm, I've done this in the past. Especially when using DLLs like Webview2.dll, MITAB.dll, blas.dll etc.
Unfortunately, not everyone has the capability of running msi's on their...
-
Hi Sergios,
Do not copy and paste! Installation instructions:
* In your VBA project, right click on your classes folder and select import file.
* Import stdLambda.cls
* Import...
-
Can see these
WebSocketCreateClientHandle
WebSocketBeginClientHandshake
WebSocketEndClientHandshake
WebSocketCreateServerHandle
WebSocketBeginServerHandshake
WebSocketEndServerHandshake
-
Hi @loquat you can't use stdLambda in an Excel formula. Formulae does not support Objects. It is designed strictly for VB6/VBA usage only. If you really must use it within excel formulae then you...
-
No difference, always 20 bytes, which makes sense, we use Longs. There should only really be a difference if LongPtr is used.
-
Damn, never knew that, that is really useful thanks! Really too bad there isn't a download button for this forums knowledge :P
That's where copy paste takes you... Thanks as always, should be...
-
Yes I realise that indeed, but Ptrsafe declares and LongPtr are concepts added in VBA7, so a check for VBA7 suffices from the point of view of declaration :) But this is why I checked for win64 when...
-
Ooo!! Great catch, totally missed that potential issue!
Interesting idea! I'll certainly give that a go. If not I'll look into constructing a byte array instead :)
Edit: Just tested and...
-
Hi All,
Thought you might appreciate this clipboard management class. It should work in VB6 assuming I have the declares setup correctly.
The source code can be found here:
stdClipboard.cls
-
Wowee! Now I'm gutted I can't seem to use these APIs in VBA... They seem to be weirdly embedded in the VBE7.dll but not accessible... And for whatever reason that means I can't import them from...
-
This is a really nice article Trick. I'm quite surprised no one has made a ASM-->HEX compiler in VB6 now, as this stuff seems relatively unobscure... Definitely a really worthwhile resource :)
-
So in the end I didn't really come up with a proper solution but I did come up with a solution which is ridiculously ugly but works for what I needed... :lol:
Behold, the behemoth:
Sub t()...
-
Damn that looks fantastic! I've barely messed around with UI in VBA and have for a long while been yearning for a custom canvas control. Also been wanting to add a "highlight" function to my stdAcc...
-
I had wondered about that, but do you know the declaration specification?
-
Waiiit... The value is multiplied by 4?! Woops... That's the ptr size right?
I used the vtable order from here:...
-
You may :) It's for a class I am working on which wraps enumerable "things". Currently I only offer a wrapper around IEnumVARIANT i.e.
For each x in pObject
'...
Next
However I want...
-
Hi All,
I've been trying for the past few hours to call IEnumVARIANT::Next() on a collection Enum. I would like this as I am building a wrapper for EnumVARIANTs giving them more possibilities.
...
-
There are some things with WinHTTP which I find unintuitive. So providing a better interface was the main motivation :)
That said I'd still like to know if anyone knows the key differences /...
-
The way I see it, there are 3 options here:
WinHttp.WinHTTPRequest.5.1 - https://docs.microsoft.com/en-us/windows/win32/winhttp/winhttprequest
Microsoft.XMLHTTP -...
-
Over the past year I've been simultaneously working on a "VBA-Like" to "VBA" transpiler with the intention of making something akin to BabelJS but for VBA. Was also hoping that might be able to...
-
Lambda Expressions
I've already posted this library elsewhere but figured that people on VBForums would find it useful too! This library has confirmed VB6 support!
Up to date documentation can...
-
Google is your friend, this is the wrong thread, but googling WM_GETOBJECT Excel, will help get you on the right track
-
Hi All,
So I've been building an expression parser (mainly for VBA but I'm sure you can use VB6 also :)). In testing that parser we came across a performance issue. One of my suggestions was to...
-
Yes. All these tests have been done in the VBA environment on both Mac and Windows. If someone could run these over VB6 P-Code and VB6 compiled native code this would be really useful! I will be...
-
So I made a post on StackOverflow regarding what I learnt from here and ultimately got criticised from mods who, rightly, thought it was all speculation.
So I actually started to do some analysis...
-
it took me a while to understand what you meant by member lol, but i see now yes that would make a lot of sense. I more so meant in the case where A is a local variable I.E.
Sub test
Dim A...
|
Click Here to Expand Forum to Full Width
|