Okay, I give up!!!

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Where's the counter operation/method to
Line Input #filenumber, varname ??
VBA gives a compiler error with a statement
like: "Line Output #filenumber, varname"

Thanks,
Bill
 
Bill said:
Where's the counter operation/method to
Line Input #filenumber, varname ??
VBA gives a compiler error with a statement
like: "Line Output #filenumber, varname"
Click to expand...


Print #filenumber, varname
 
Where's the counter operation/method to
Line Input #filenumber, varname ??
VBA gives a compiler error with a statement
like: "Line Output #filenumber, varname"

Thanks,
Bill
Click to expand...

I use Print to write to files, eg...

i = FreeFile()
Open GetLogFileName For Append As i
Print #i, Now() & ": Something"
Close #i

Is this what you were looking for?
 
Just changed the "Line Output #2, varname" to
"Print #2, varname" and everything went as
desired.
Thanks,
Bill
 
If you ever want double quotes encapsulating text field data you can also use

Write #1, WhateverHere

Write will include double quote text delimiter and Print excludes it.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
If my post was helpful to you, please rate the post.
__________________________________
 
You shouldn't hard-code the file number: you can never be sure what else is
running and is using the file handle you hard-coded.

Instead, use the FreeFile function to assign a file number for you, like
Minton did in his example.
 
Back
Top