msoFileDialogFilePicker alternative for Excel for Mac

Question

Hi.

I've read that msoFileDialogFilePicker doesn't really work for Excel for Mac. Is there a way to rewrite this so it works on Mac? I don't really want to buy a new computer just for this one report.

Sub macro()

Dim ingcount&, i&, sFname$

Dim wb As Workbook, wbT As Workbook, ws As Worksheet

Set wbT = ThisWorkbook

With Application.FileDialog(msoFileDialogFilePicker)

.Filters.Add "¯__®¨®€Ëì", "*.txt", 11

.InitialFileName = "*.txt*"

.Title = "INSERT RAW DATA"

.AllowMultiSelect = True

Application.ScreenUpdating = False

Application.DisplayAlerts = False

If .Show = vbFalse Then Exit Sub

For ingcount = 1 To .SelectedItems.Count

Set wb = Workbooks.Open(.SelectedItems(ingcount))

sFname = wb.Name

i = InStr(1, sFname, ".")

sFname = Left(sFname, i - 1)

wbT.Sheets(sFname & " RAW DATA").UsedRange.Clear

wb.Sheets(1).UsedRange.Copy

wbT.Sheets(sFname & " RAW DATA").Range("A1").PasteSpecial

wb.Close False

Next

End With

Application.ScreenUpdating = True

Application.DisplayAlerts = True

MsgBox ("Completed")

    Sheets("INSTRUCTION").Select

    Range("I1").Select

End Sub

Thank you in advance for the help.

Answer 1

Hi

This page explains how to use File dialogs in Excel for Mac: https://macexcel.com/examples/filesandfolders/

Answer 2

No similar libary for VBA for Mac.

I guess you need rewrite it with other language e.g. PHP or Go language.