I am trying to adapt this part of a current macro to work with Excel on a MAC
Dim myLabel As String
myFile = Application.GetOpenFilename("All Files,*.*")
Workbooks.Open _
Filename:=myFile
On Error Resume Next
When the current macro is run, the following error comes up:
Run-time error '1004'
Method 'GetOpenFilename' of object'_Application' failed
Any help would be greatly appreciated! Thanks!!
Dim myLabel As String
myFile = Application.GetOpenFilename("All Files,*.*")
Workbooks.Open _
Filename:=myFile
On Error Resume Next
When the current macro is run, the following error comes up:
Run-time error '1004'
Method 'GetOpenFilename' of object'_Application' failed
Any help would be greatly appreciated! Thanks!!