Forum Discussion
JosephAdedeji
Apr 25, 2022Copper Contributor
VBA Issue - Application.FileDialog return Nothing
Is there something wrong with the lines of code below? It results in the following error. Sub CountFiles()
Dim xFolder As String
Dim xPath As String
Dim xCount As Long
Dim xFiDialog ...
- Apr 25, 2022
I don't think FileDialog works on a Mac. See Loop through Files in Folder on Mac for an alternative.
JosephAdedeji
Apr 30, 2022Copper Contributor
Thanks Hans!
HansVogelaar
Apr 30, 2022MVP
You're welcome!