MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

How to write to console

  Asked By: Donna    Date: Oct 20    Category: MS Office    Views: 1013

I am processing a text file using Excel VBA line by line. I want to write to
console(DOS Prompt) the line which I am processing.



4 Answers Found

Answer #1    Answered By: Funsani Chalthoum     Answered On: Oct 20

Why do you want to do this? Would it be just as good to write  to the
immediate window?

Answer #2    Answered By: Randall Franklin     Answered On: Oct 20

But Writing into console, would help me display
the record that is being processed.

Answer #3    Answered By: Josie Roberts     Answered On: Oct 20

If you really must... then one way to go, and I'm not saying the only
way, is to create a .BAT file  to echo and shell that.. or even maybe
shell the echo itself.

Whatever you do, I think you will need to either shell to a DOS
command or program or start a WSH script.. which I think is also a
shell process.

But I really don't see why you can't write  to the immediate window.
Another option may be to write to the status line... and maybe even
use MsgBox

Answer #4    Answered By: Marc Anderson     Answered On: Oct 20

Why not use:

Application.StatusBar = SomeMessageRelatingToTheCurrentRecord

What are you hoping to acheive by sending output to a dos box?

Didn't find what you were looking for? Find more on How to write to console Or get search suggestion and latest updates.