Hi all,
I am encountering something a little odd.
I used Excel 2011 for mac to create my spreadsheet.
It has some VBA in it, and until now, all worked well.
Then I installed Excel 2016 for Mac, and now, at a specific point in my code, see below,
it throws me out with a Runtime error 70: Permission denied.
Range value is a string that matches exactly the name of the file I want to use for the fill attributes.
That used to worked very well before.
Anyone would have any idea ?
Thanks a lot.
C.
I am encountering something a little odd.
I used Excel 2011 for mac to create my spreadsheet.
It has some VBA in it, and until now, all worked well.
Then I installed Excel 2016 for Mac, and now, at a specific point in my code, see below,
it throws me out with a Runtime error 70: Permission denied.
shp1.Fill.UserPicture (ActiveWorkbook.Path & Application.PathSeparator & "labels" & Application.PathSeparator & Range("$C$6").Value & ".png")
Range value is a string that matches exactly the name of the file I want to use for the fill attributes.
That used to worked very well before.
Anyone would have any idea ?
Thanks a lot.
C.