copy, ALT-Tab, Paste... SENDKEYS? APPACTIVATE?

I have joined this message board after trying for a couple weeks to figure this out. I have read a ton a messages on many different site, and still can't seem to figure this one out... Thank you in advance for any help guys!
Sooooo..... Work at distribution center in Customer service. 2 monitors running windows, however our order entry runs in DOS.
There are a few long sentences that I have to type, during the day, doing various request..
IE: checking stock and ETA, please and thank you, Jordan. First I made an excel Doc with all of these in their own cell. All day long I click the cell, Ctrl-C, ALT-TAB, ALT-V (Paste in dos) CTRL-V in dos crashes the program and is a HUGE issue.
MY goal- is to click a cell, have it copy, switch to previous window, and paste.
I'm not even sure it's possible, I see people talking about "SendKeys" I'm super new to VBA and don't seem be able to figure it out.
So far....
I right clicked on Sheet 1 and went to view code. and pasted this in

Please Login or Register  to view this content.

That copies the cell when I click it(which is saving a little time, but I'm unable to figure out what is next, to switch to previous dos window, and paste (ALT-V)

Again, any help would be much appreciated

I haven't really used Sendkeys, and on the surface it seems like it can work for you, but then I read some of the odd behaviors, so it is hard to recommend. But, certainly start there and see how far it takes you. It seems the preferred coding environment for this type of request is .net, but that opens up another set of worms. Maybe find a .net forum that is willing to help you if this proves to be a dead end.

Alternatively, I know there are some apps/keyboards that let you set up macros that essentially type the commands you want. Gaming keyboards tend to have these abilities. That may be a cleaner solution. One app I found was MacroExpress. I don't know how legit it is, but it shows that there are some other solutions out there.

Hello Jeasy,

Welcome to the forum!

DOS windows or Command Prompt windows do not operate the same as a standard window. This is way Ctrl+V fails to paste the text. SendKeys will also fail since the DOS window is not in the same process as the Workbook.

To paste text into a DOS windows requires using Windows API. The macro below will paste the data in cells "A1:A2" of the ActiveSheet. You can change this range to what you are using. The cells contents will be pasted to the DOS window and executed.

Add a new VBA Module to your Workbook's VBA project. Copy and paste all of the code below into it.

Please Login or Register  to view this content.

Change the range and worksheet to match what you are using.

Please Login or Register  to view this content.

Hello Jeasy,

You're welcome. This is the first time anyone has wanted to this that I know of and I have never seen code to do it. I learned a lot by doing this, so thanks for that.