converting VBA macro from win 7 to MAC

**joedhk** · 03-23-2019, 08:58 PM

Hi,
I have created a VBA macro in windows 7 to populate PDF i works fine in windows 7.But when i run it in MAC operating system its gives error.the code is

' Write FDF file to disk
    If Len(vClient(1, 1)) Then sFileName = vClient(1, 1) Else sFileName = "FDF_DEMO"
    sFileName = ActiveWorkbook.Path & Application.PathSeparator & sFileName & ".fdf"
    lngFileNum = FreeFile
    Open sFileName For Output As lngFileNum
    Print #lngFileNum, sTmp
    Close #lngFileNum
    DoEvents
    
    ' Open FDF file as PDF
    ShellExecute vbNull, "open", sFileName, vbNull, vbNull, SW_NORMAL
    Exit Sub

ErrorHandler:
    MsgBox "MakeFDF Error: " + Str(Err.Number) + " " + Err.Description + " " + Err.Source

End Sub

This code creates a fdf file in Mac operating system but gives error :

MakePDF error: 53 file not found:
shell32.dll VBAproject.

someone help me please.