<Chuckle> Remember I said I'm not used to using native Basic commands for I/O? That's getting in the way, here. I'm not sure, but I think you're saying this:
Quote:
|
Some of the lines I want have commas in them. For example, some of them say "45", but others say "45, 46, 47". In the latter case, after the statement "Input #1, A", I want A to equal "45, 46, 47" but all I actually get is "45". How do I get my VBA program to get all of "45, 46, 47" from a line in the file?
|
Is that what you're asking? If so, I think there's way to do it even using the native Basic commands, but I'll have to look it up. Is anyone else reading this who knows?
If no one answers, and I can't find it, then you can switch to using the FileSystemObject, which I know works. But first let's see whether you or I can find, or some lurker can tell us, the right form of the Input statement.