Search:

We might be all right, and we might be all wrong.
My point is, that you can overload subs, too, which don't have a return type, and that you can call functions as if they were a sub.

Bottom line...

How would that work?
if it‘s not registered, then a TLB is like any other file (like a something.txt).
The only approach for not registered TLB‘s to keep them „close“ to the app (e.g. their own...

Niya,
i don‘t know C#, but in vb6 we always had the possibility to call a function as if it‘s a sub (and thusly ignoring the return type).
I‘d hazard a guess that‘s the reason, because a compiler...

That would be the correct way.
AFAIK, when determining WHICH overload to call the Return Type (if even existent --> Sub instead of Func) is ignored!
(But it might differ from language to language)

If the tlb is registered, you can look it up in the Registry
You would need the GUID for it though.
https://docs.microsoft.com/de-de/windows/win32/api/oaidl/nn-oaidl-itypelib?redirectedfrom=MSDN...

Don't forget the Order of the ParamTypes.
Count and Types can be the same for two Overloads, just Order is different

If first String And second Long and third Double Then NukeMoscow
ElseIf First...

Both Members are 4 Bytes long, oInst = unsigned Integer 32-Bit, *lpvarValue = Pointer to Something

so
UnionMember As Long

Yeah, i know, but i still say: it depends, what the original code (the code to be transpiled) is actually doing, because if it's really just emulating Optional Parameters, it would create redundant...

Exactly what i was talking about (Polymorphism).
In this example the vb6-analogy would be


Sub DoSomething(p As Variant)
If TypeOf(p)=vbString
DoThis
ElseIf TypeOf(p)=vbInteger...

Would have to disagree in this particular case.
I repeat: It depends what the underlying source-code is doing.

In your example, all (overloaded) Function-Signatures have in common the Parameter...

Only if you translate the .NET-Function-Calls "1 to 1", then yes, but also in regards to Niya's answer:

What's easier?
Deciding which of the 8 Functions to explicitely call (depending on the...

Why are you reinventing the wheel?
https://www.vbforums.com/showthread.php?782765-How-to-parse-HTML-and-XML-files-in-VB6

Function GetProperty( _
ByVal name As String, _
Optional ByVal returnType As Type, _
Optional ByVal types() As Type, _
Optional ByVal modifiers() As ParameterModifier, _
Optional ByVal...

Checking against UBound = -1 is nonsense, since UBound(array) = -1 is a valid upper Bound for e.g. Dim MyArray(-5 To -1) As SomeType

An Array with Length=0 IS "Dim MyArray() As SomeType", since...

Confirmed behaviour in O365
Never noticed it, since when i'm in the VBA-Editor (ALT+F11) i never hit that combination again

If you don‘t have it that way in the database, the only way as tg wrote:
a SELECT UNION ALL

There is no "one thing that hides everything".
you have to iterate either through
a) your Control-Array of Labels, setting each Member to invisible
b) the Control-Collection of the Form containig...

Label.Visible = False

*gazing into my crystal ball*
*the answer is there*
.
.
.
Huh? My Crystal Ball just had a Blue Screen of Death
probably meaning it couldn't find an answer, because there is "none" (which even...

That's what i was talking about.
I'd even make an own "Manufacturer"-Table, and then point its PrimaryKey to a ForeignKey to this "Monitor"-Table

Table Manufacturer
ID (Primary Key)
Description...

Your point?
What do you think the result is of my sample query?


SELECT Blbalbabla FROM SomeTable WHERE ARealDateColumn BETWEEN #2022-04-01# AND #2022-06-30#
Returns all "Blablablbla" for...

Add a Column "Manufacturer".....

https://stackoverflow.com/questions/4234941/vb-net-2010-to-connect-to-ms-access-database

Are both Apps written in VB6?
1) If yes, you could compile them as ActiveX-EXE's, and reference them to each other. That way you could use Public Objects and their methods
1b) Write an ActiveX-Dll...

It's an Access-DB
Now it depends: is OP wanting to execute the SQL from within Access, then he can use Replace within the SQL-Statement,
If it's from "outside" (e.g. from a VB6-Cllient) then he's...

Why in the name of the holy 8 bits do people always seperate Dates (and Times) into its individual components?

And name your Database-System!
SQLite, Access, MySQL?


SELECT Blbalbabla FROM...

OK, just looked at it again.
He examines the value in wsManual.Cells and takes this as the Column(Offset) to place the value in wsKD

Hmm.....me thinks you could solve this even without VBA, but...

Why did i just read "can generate a mayonnaise"......

Have you thought about using an ADODB-Recordset with your sheet as its source?
The Query could be like

rs.Open "SELECT * FROM [Sheet1$C3:Z20]", connection
Then you could use...

Untested


Dim tmpStr As String
Dim Index As Long
If List9.ListIndex>0 Then
Index=List9.ListIndex
tmpStr=List9.List(Index)
List9.Selected(Index)=False
List9.RemoveItem Index

And your question is what?

Not knowing how LynxGrid works, this confuses the hell out of me:
Is LynxGrid recognizing vbTab as the Cell-"Delimiter"?
because for me, that's adding one Item (which is basically a concatenated...

I wouldn't be surprised, if the AddItem-Function(!) returns the RowNumber of the Grid where it was added

Nevermind that an "AddItem" implies adding a Row automatically, and he's doing that three...

IIRC, "As Any" is used when you want to pass a pointer to an API which accepts different types (that pointer points to) for the same function, so you don't have to write (multiple) Aliases for each...

My money is on Printer not reachable

Since it is a company network printer, i'd hazard a guess it has a static IP.
Try to reach the IP-Address before creating the DC?

As a workaround (and i've seen it in use):
You have a global, dynamic Array of Strings


'Somewhere "global"
Public MyStringArray() As String

in modMain

Yes, SQL is the way to go
(and this thread to the Database-Forum)

Correct.
I fell for that trap before i found out about DisplayFormat.
Question: How do you "trigger" the vba-code now?
I've seen mention to use Worksheet_Change resp. Worksheet_Calculate-Event for...

After researching this: The Problem is conditional Formatting.
You cannot use DisplayFormat in any UDF, only directly in VBA-Code