The Excel Font Generator Tool "copy to clipboard" doesn't work on windows 10. But I found a solution.

[Cherianpaul]

IMPORTANT

Before submitting this issue
[] Have you tried using the latest version of the library?
[] Have you checked this has not already been submitted and/or resolved?
[ ] If you are requesting help a better choice may be the Arduino forum

Subject of the issue

The Excel Font Generator Tool "copy to clipboard" doesn't work on windows 10. But I found a solution.

Your Environment

Library Version:
Arduino IDE version:
Host OS and Version:
CPU Hardware model/type:
Matrix hardware model/type: [ ] Parola [ ] Generic [ ] ICStation [*] FC-16 [ ] Custom (describe how wired)

Steps to Reproduce

It is not with Arduino code, it is about the Excel Font Generator Tool.

Expected Behaviour

It should copy the generated array into clipboard.

Actual Behaviour

It does not copy as obj.PutInClipboard does not work on windows 10.

Code Demonstrating the Issue

MyDataObj.PutInClipboard

[Cherianpaul]

Solution found from this link : https://chandoo.org/forum/threads/clipboard-copy-vba-code-not-working-in-windows-10.37126/post-223256

Option Explicit
#If Mac Then
' ignore
#Else
#If VBA7 Then
Declare PtrSafe Function GlobalUnlock Lib "kernel32" (ByVal hMem As LongPtr) As LongPtr
Declare PtrSafe Function GlobalLock Lib "kernel32" (ByVal hMem As LongPtr) As LongPtr
Declare PtrSafe Function GlobalAlloc Lib "kernel32" (ByVal wFlags As Long, _
ByVal dwBytes As LongPtr) As LongPtr

    Declare PtrSafe Function CloseClipboard Lib "User32" () As Long
    Declare PtrSafe Function OpenClipboard Lib "User32" (ByVal hwnd As LongPtr) As LongPtr
    Declare PtrSafe Function EmptyClipboard Lib "User32" () As Long

    Declare PtrSafe Function lstrcpy Lib "kernel32" (ByVal lpString1 As Any, _
                                                     ByVal lpString2 As Any) As LongPtr

    Declare PtrSafe Function SetClipboardData Lib "User32" (ByVal wFormat _
                                                            As Long, ByVal hMem As LongPtr) As LongPtr
#Else
    Declare PtrSafe Function GlobalUnlock Lib "kernel32" (ByVal hMem As Long) As Long
    Declare PtrSafe Function GlobalLock Lib "kernel32" (ByVal hMem As Long) As Long
    Declare PtrSafe Function GlobalAlloc Lib "kernel32" (ByVal wFlags As Long, _
                                                 ByVal dwBytes As Long) As Long

    Declare PtrSafe Function CloseClipboard Lib "User32" () As Long
    Declare PtrSafe Function OpenClipboard Lib "User32" (ByVal hwnd As Long) As Long
    Declare PtrSafe Function EmptyClipboard Lib "User32" () As Long

    Declare PtrSafe Function lstrcpy Lib "kernel32" (ByVal lpString1 As Any, _
                                             ByVal lpString2 As Any) As Long

    Declare PtrSafe Function SetClipboardData Lib "User32" (ByVal wFormat _
                                                    As Long, ByVal hMem As Long) As Long
#End If

#End If
Public Const GHND = &H42
Public Const CF_TEXT = 1
Public Const MAXSIZE = 4096

Sub ClipBoard_SetData(MyString As String)
#If Mac Then
With New MSForms.DataObject
.SetText MyString
.PutInClipboard
End With
#Else
#If VBA7 Then
Dim hGlobalMemory As LongPtr
Dim hClipMemory As LongPtr
Dim lpGlobalMemory As LongPtr
#Else
Dim hGlobalMemory As Long
Dim hClipMemory As Long
Dim lpGlobalMemory As Long
#End If

    Dim x                 As Long

    ' Allocate moveable global memory.
    '-------------------------------------------
    hGlobalMemory = GlobalAlloc(GHND, Len(MyString) + 1)

    ' Lock the block to get a far pointer
    ' to this memory.
    lpGlobalMemory = GlobalLock(hGlobalMemory)

    ' Copy the string to this global memory.
    lpGlobalMemory = lstrcpy(lpGlobalMemory, MyString)

    ' Unlock the memory.
    If GlobalUnlock(hGlobalMemory) <> 0 Then
        MsgBox "Could not unlock memory location. Copy aborted."
        GoTo OutOfHere2
    End If

    ' Open the Clipboard to copy data to.
    If OpenClipboard(0&) = 0 Then
        MsgBox "Could not open the Clipboard. Copy aborted."
        Exit Sub
    End If

    ' Clear the Clipboard.
    x = EmptyClipboard()

    ' Copy the data to the Clipboard.
    hClipMemory = SetClipboardData(CF_TEXT, hGlobalMemory)

OutOfHere2:

    If CloseClipboard() = 0 Then
        MsgBox "Could not close Clipboard."
    End If
#End If

End Sub

then call it like this:
Code:
ClipBoard_SetData "your text here"

[MajicDesigns]

This will need fixing. I don't have easy access to Microsoft Office any more so it may take a while. Are you able to implement a fix and submit?

[Cherianpaul]

Parola MD_MAX72xx Font Builder v4.zip
Sure. No problem.
I attached it here.

[MajicDesigns]

Better you email the excel file directly to me.

[Cherianpaul]

Your email?

[MajicDesigns]

Oops, forgot that I made it private here. OK, try and attach the file to one of these comments. The toolbar above the text as you type has a paperclip for attachment. Not sure if there is a size limit.