C++ types > QB64 types: do we have an equivalent QB64PE page?

[madscijr]

For some API work I'm doing, I found this page useful: 

• QB64.com > C Libraries
  

Do we have an equivalent QB64PE page with this info?

---

C++ Variable Types

C Name	Description	Size	QB64 Type
_BYTE	Character or small integer.	1 byte	_BYTE
INTEGER	Short Integer(Word)	2 byte	INTEGER
LONG	Integer(Dword)	4 byte	LONG
LONG	Int32, Long integer or Long	4 byte	LONG
_INTEGER64	Long long (Qword)	8 byte	_INTEGER64
Boolean	Boolean value true or false.	1 byte	_BYTE
SINGLE	Floating point number	4 byte	SINGLE
DOUBLE	Double precision floating.	8 byte	DOUBLE
_FLOAT	Long double precision float	10 byte	_FLOAT
Unicode	Wide character(Unicode)	2 or 4
_OFFSET	void pointer(void *)	ANY	_OFFSET

---

PS Useful trick for anyone who wants to copy a table with hyperlinks from a Web page to forum post markdown quickly - you can use Excel. A couple small macros and some formulas gets you a nice reusable template. Here's the macro and see the screenshot for how to set up the formulas. Thereafter all you have to do is paste your table into the sheet and voila! the final markdown is calculated in cells M2-M(endrow). Slap that inside tags and done. (Note: if you need more than 4 columns, insert n columns, copy the formula columns over, and add the new columns to the final row mardown formula.) The ability to paste directly from rich text into the forums editor would eliminate all this nonsense but this beats manually typing in everything. 

Code: (Select All)

' /////////////////////////////////////////////////////////////////////////////
' FROM:

' vba - Extract URL From Excel Hyperlink Formula - Stack Overflow
' https://stackoverflow.com/questions/32230657/extract-url-from-excel-hyperlink-formula

' Excel VBA to extract Hyperlink from Hyperlink Formula - Super User
' https://superuser.com/questions/1313339/excel-vba-to-extract-hyperlink-from-hyperlink-formula

Public Function GetHyperLinkAddress(ByVal Target As Excel.Range) As String
    Dim RoutineName As String:: RoutineName = "GetHyperLinkAddress"
    Dim sFormula As String
    Dim sExpression As String
    Dim iStart As Long
    Dim iPos As Long
    Dim iEnd As Long
    Dim sURL As String
    Dim sSubAddress As String
    Dim sFind As String
   
    'Set Target = ActiveCell
    sURL = ""
    
    On Error Resume Next ' handle errors manually
   
    If Target.Hyperlinks.Count > 0 Then
        sURL = Target.Hyperlinks(1).Address
        sSubAddress = Target.Hyperlinks(1).SubAddress
        If Len(sSubAddress) > 0 Then
            sURL = sURL & "#" & sSubAddress
        End If
    ElseIf Target.HasFormula Then
        sFormula = Target.Formula
        sFind = "HYPERLINK("
        iPos = InStr(1, sFormula, sFind, vbTextCompare)
        If (iPos > 0) Then
            iEnd = InStr(iPos + 1, sFormula, ",", vbTextCompare)
            If (iEnd > 0) Then
                iStart = iPos + Len(sFind)
                sExpression = Mid(sFormula, iStart, iEnd - iStart)
                sURL = Evaluate(sExpression)
            End If
        End If
    End If
   
    If Err.Number <> 0 Then
        Debug.Print CStr(Now) & " " & RoutineName & " failed with error #" & CStr(Err.Number) & ": " & Err.Description
        Err.Clear
        sURL = ""
    End If
    
    On Error Goto 0 ' resume automatic error handling
    
    GetHyperLinkAddress = sURL
End Function ' GetHyperLinkAddress

' /////////////////////////////////////////////////////////////////////////////

Public Function GetURL(ByVal Target As Excel.Range) As String
    Application.Volatile
    GetURL = GetHyperLinkAddress(Target)
End Function ' GetURL

[a740g]

This?

C Libraries - QB64 Phoenix Edition Wiki

[madscijr]

This?

C Libraries - QB64 Phoenix Edition Wiki

Yes - thanks...

[grymmjack]

For some API work I'm doing, I found this page useful: 

---

PS Useful trick for anyone who wants to copy a table with hyperlinks from a Web page to forum post markdown quickly - you can use Excel. A couple small macros and some formulas gets you a nice reusable template. Here's the macro and see the screenshot for how to set up the formulas. Thereafter all you have to do is paste your table into the sheet and voila! the final markdown is calculated in cells M2-M(endrow). Slap that inside tags and done. (Note: if you need more than 4 columns, insert n columns, copy the formula columns over, and add the new columns to the final row mardown formula.) The ability to paste directly from rich text into the forums editor would eliminate all this nonsense but this beats manually typing in everything. 

This is awesome! You should make a video tutorial showing us how to do this

Well done!!!

[madscijr]

For some API work I'm doing, I found this page useful: 

---

PS Useful trick for anyone who wants to copy a table with hyperlinks from a Web page to forum post markdown quickly - you can use Excel. A couple small macros and some formulas gets you a nice reusable template. Here's the macro and see the screenshot for how to set up the formulas. Thereafter all you have to do is paste your table into the sheet and voila! the final markdown is calculated in cells M2-M(endrow). Slap that inside tags and done. (Note: if you need more than 4 columns, insert n columns, copy the formula columns over, and add the new columns to the final row mardown formula.) The ability to paste directly from rich text into the forums editor would eliminate all this nonsense but this beats manually typing in everything. 

This is awesome! You should make a video tutorial showing us how to do this

Well done!!!

Thanks, it feels like such a kludge! 

If we can't find a control to let you paste tables / rich text directly into the forum editor, what I'd really like to do is make a QB64PE utility that reads a rich text table or range of Excel cells directly from the clipboard and auto-generates the markdown. I'm not sure what kind of API or QB64 wizardry we would need to make that work, anybody got any ideas?? 

I'll post an Excel tutorial when I get a chance... not today! LoL

[grymmjack]

I think if you use bbcode...

Code: (Select All)

[table][/table]
[tr][/tr]
[td][/td]

That'd work? Like what @SMcNeill posted, etc.