Output result on Command Prompt

[questionit]

How to output anything on Dos Prompt using VBA?

And how to read line in Dos Prompt?

Thanks

[MMcCarthy]

How to output anything on Dos Prompt using VBA?

And how to read line in Dos Prompt?

Thanks

questionit

You have been a member now for long enough to know that you need to give a lot more information than this to get an answer to your question. My immediate reaction to what you are asking is that VBA is an application language tied to MS applications.

However, if you can tell us what you are trying to do and why we will see what kind of solutions are possible.

Mary

[questionit]

I want to open up Dos Prompt to output any information using VBA.

Can you tell me how it can be done

Thanks

questionit

You have been a member now for long enough to know that you need to give a lot more information than this to get an answer to your question. My immediate reaction to what you are asking is that VBA is an application language tied to MS applications.

However, if you can tell us what you are trying to do and why we will see what kind of solutions are possible.

Mary

[MMcCarthy]

I want to open up Dos Prompt to output any information using VBA.

Can you tell me how it can be done

Thanks

questionit

What part of give more information didn't you understand?

What exactly are you trying to do and why? You question doesn't make any sense in its current form which is why it remained unanswered for so long.

[questionit]

I thought i made it very simple

Here it is again :

We can output some text in windows with MsgBox()

Can we not open Dos Prompt and display some message on it or use any of the DOS commands to do something?

questionit

What part of give more information didn't you understand?

What exactly are you trying to do and why? You question doesn't make any sense in its current form which is why it remained unanswered for so long.

[MMcCarthy]

I thought i made it very simple

Here it is again :

We can output some text in windows with MsgBox()

Can we not open Dos Prompt and display some message on it or use any of the DOS commands to do something?

So you want to know if you can automate the opening of DOS from VBA. Run some commands and close it again?

[MMcCarthy]

So you want to know if you can automate the opening of DOS from VBA. Run some commands and close it again?

This is known as the Shell function.

Have a look at this question

http://www.thescripts.com/forum/thread550710.html