By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,484 Members | 1,811 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,484 IT Pros & Developers. It's quick & easy.

Output result on Command Prompt

100+
P: 553
How to output anything on Dos Prompt using VBA?

And how to read line in Dos Prompt?

Thanks
Jul 19 '07 #1
Share this Question
Share on Google+
6 Replies


MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jul 30 '07 #2

100+
P: 553
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
Jul 31 '07 #3

MMcCarthy
Expert Mod 10K+
P: 14,534
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.
Jul 31 '07 #4

100+
P: 553
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.
Jul 31 '07 #5

MMcCarthy
Expert Mod 10K+
P: 14,534
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?
Jul 31 '07 #6

MMcCarthy
Expert Mod 10K+
P: 14,534
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
Jul 31 '07 #7

Post your reply

Sign in to post your reply or Sign up for a free account.