79830003

Date: 2025-11-25 17:11:08
Score: 0.5
Natty:
Report link

I did not. I used the built-in OPEN, GET, PUT, and CLOSE statements; because, I was told they were faster. However, I just asked the AI specifically about binary stream I/O (answer follows). So, as best practice, I guess it is better to use ADO for binary output. Thanks.

For binary stream I/O in Excel VBA, the MS ADO (ActiveX Data Objects) Stream object is generally the superior choice over the built-in OPEN, GET, PUT, and CLOSE statements. ADO Stream is faster, more reliable, and offers greater flexibility, particularly with file handling and character encoding.

Reasons:
  • Blacklisted phrase (0.5): Thanks
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (0.5):
Posted by: Dave Clark