Ever wondered what is the difference between a VBA macro “Write” and “Print” funtion?
Here is the difference with an example.

strFName = “c:\temp\xynet.txt”
Open strFName For Output As #1
Write #1, “ABC”
Close #1

OUTPUT
Xybernetics Excel VBA Write Text File Write Vs Print
ABC

strFName = “c:\temp\xynet.txt”
Open strFName For Output As #1
Print #1, “ABC”
Close #1

OUTPUT
Xybernetics Excel VBA Write Text File Write Vs Print

n1849778
About the
I am a software developer in Calgary, Alberta, Canada with passion in getting my fingers in any new technology. I started software development when I was 10 years old and have never looked back. Now with well over 35 years of software development, I wanted to share some of these key knowledge with the people of the world in the wide web.