The error I get is "invalid argument". If I export from the ribbon menu it is working properly (commas are replaced by semicolons within the multivalued field) but the VBA module, for some reason, does not digest multivalued fields. Can anybody enlighten me?
Do you need it to export to Comma Separated file? I had no idea what a multivalued field was, thanks for the link. I would suggest changing the delimiter to another character to see if it works.
To change the delimiter to anything you want (I will use the | pipe character on occasion) try exporting your table manually. When the export wizard appears click the Advanced button. Choose your export spec and then change the Field Delimiter to anything you want . You can type any character in the field. Then save you spec and try your code again.