Problem with Workbooks.Open("Path) on Excel 2016 for Mac

Hi and welcome to the forum.

What code are you using? Better still upload the workbook that contains the macro.

Hi Richard,

Thank you for your quick response !!

I am for now just testing, my workbook is still empty, the first step is copying the data from an initial workbook, since it will be variable.

The code is :

HTML Code: 

I am actually working a dashboard so i need to copy the new month's data each time into a hidden sheet and apply my macros on it (Mainly generating graphs etc), do you think this is a good idea ?

It's often not abolutely necessary to copy data from one workbook to another since you can link or connect directly.

But what code are you using in the testing? Or are you saying you're trying to do it manually and having problems?

Have you tried recording a macro which is often a good starting point, and then editing and generalising the code once you have the basics.

have you saved your file with the macro in the folder you want to be used as 'thisworkbook.path'?
I don't have a mac but that is the error i get if i just paste it in a workbook without saving it.

Why is there a space after the xls? Also, are you using 2016 on the Mac too?

Does

Please Login or Register  to view this content.

return what you expect to see? It is possible, I suppose, that you are running into a sandboxing problem.