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.
HansVogelaar
Apr 25, 2022MVP
I don't think FileDialog works on a Mac. See Loop through Files in Folder on Mac for an alternative.
- JosephAdedejiApr 30, 2022Copper ContributorThanks Hans!
- HansVogelaarApr 30, 2022MVP
You're welcome!