see /en-us/article/Add-remove-or-change-a-trusted-location. Click that and find the style in the list, and the instructions in this article then apply. Excel for Mac 2016 Macro Warning message click Enable Macros for.
But because the VBA generates an error nothing is written so the file is zero bytes. In Mac Word 2011 the styles pane is also on the Home tab, in the Styles section but instead of the small arrow-like icon it is a much larger icon that looks like a window with a header/tool bar and a blue circle with a white paragraph mark in it. All the individual words also work fine so it doesn't seem to be an encoding issue and if I generate a long filename the same length it's fine as well.Īlso just to add, the Open filePath & filename For Output As #1 does actually generate a file with the correct filename in the correct location. It's definitely the filename causing an issue as if I change it to ':test.csv' as an example it works. Open filePath & filename For Output As #1Įxample argument that causes an error is: filePath : 'Untitled:Users:ooo:Desktop:New' : Stringįilename : ':FloridaRhum Barbancourt 5 Star Reserve Speciál 8 Years Old.csv' : String I have the following function which produces a runtime error 52 (bad filename or number) only on Mac on the line Open filePath & filename For Output As #1 Function ExportAsCSV(ByVal charToEncode As String, _īyVal filePath As String, ByVal filename As String) As Boolean
