vba写入utf8文件不带bom格式

帮一个人解决vba的问题,被vba坑了一把,vba写入utf8的时候也写入了bom头,非常讨厌,以前写C#经验是直接文件操作写入方式为binary,可是在vba下,貌似utf8跟type=2似乎没有效果,这一点也就是老外提到的第一点如下:

1. Put the text into the buffer as UTF-8, Type=2, but then set Type=1 (as binary) and write that out. That might convince ADODB.Stream to skip adding the BOM.

2. Create a