0

I have a macro to save worksheets that works on Windows but the user's laptop is a Mac. It errors on this line and gives the error message "ActiveX can't create object" or something close to this. How can I change this line of code to be consumable by Mac?

   If fsoFSO.FolderExists(fp) Then
       MsgBox "FOLDER - " & fp & " ALREADY EXISTS, DELETE CONTENTS TO PROCEED"
       Exit Sub
   Else
       fsoFSO.CreateFolder fp
   End If
braX
  • 10,905
  • 5
  • 18
  • 32
d3mozs
  • 43
  • 7

0 Answers0