Daniel Darvill
Active Member
Joined: Jul 7, 2020
Follow
RE: Excel cannot open this file - The file format or file extension is not valid.
Managed to fix it by changing Workbooks.Add to Workbooks.Open No idea why that worked but it did! Thanks for your help Dan
5 years ago
Forum
RE: Excel cannot open this file - The file format or file extension is not valid.
Hey Philip, Yeah its very strange - it works fine on my PC too. On the Mac it is throwing the error on the following line: Set wbk2 = Work...
5 years ago
Forum
Forum
Replies: 5
Views: 112