MRMovie's example looks very good, short and sweet, but I've always thought reading a file took longer than doing a skip. This example takes a bit more code to get the number of lines, but never actually reads the file contents:
' get the number of lines in the input file
' first, get the...
Check out http://vbaccelerator.com/home/VB/Utilities/ActiveX_Documenter/article.asp. This solves at least part of the problem, but knowing which files to open that have automamtion interfaces is still hit and miss for me.
Mark
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.