macro to run dos command

[geno607]

any idea how to create a macro to run a dos command to open a cash drawer?

 

[RoryA]

Welcome to the forum.

You can usually use Shell to do that. What is the DOS command?

 

[geno607]

Welcome to the forum.

You can usually use Shell to do that. What is the DOS command



echo ^G > COM4

the character before the G is done in dos by holding down the crtl button while pressing G

 

[RoryA]

You can probably use something like this:

Shell "Cmd /k echo ^G > COM4", vbhide

 

[geno607]

You can probably use something like this:

Shell "Cmd /k echo ^G > COM4", vbhide

I appreciate the help, I copied that and pasted that into the macro, it doesnt run.
I think the problem is that ^G it has to be done in with the crtl button pressed with the letter G.
dos doesn't recognize it with the
when I do that in the macro it wont recognize that key stroke.

http://www.starmicronics.com/absolu...icronics_CashDrawer_OpenFromCommandPrompt.pdf

here is the info from star micronics for the command to open the drawer. I really appreciate any help.
I have created a spread sheet to use for the cash control report for the end of day. one of the buttons needs to open the cash drawer

 

[RoryA]

I can't test, but does this work?

Shell "Cmd /k echo " & chr(7) & " > COM4", vbhide

 

[geno607]

I can't test, but does this work?

Shell "Cmd /k echo " & chr(7) & " > COM4", vbhide

Thats it! Your good, Can you explain the script?

Thank you very much.
Gene

 

[RoryA]

Cmd runs the command prompt.
The rest is the same as you would type at the command prompt, other than the ^G can't be typed as a literal ^ sign followed by a G, it's actually (according to my searches) equivalent to the ASCII character code 7, which is what the Chr(7) part recreates.

 

[geno607]

Cmd runs the command prompt.
The rest is the same as you would type at the command prompt, other than the ^G can't be typed as a literal ^ sign followed by a G, it's actually (according to my searches) equivalent to the ASCII character code 7, which is what the Chr(7) part recreates.

Thanks again, I knew I had stopped at the right place. So many avenues on the net. Appreciate the help.

 

[RoryA]

Glad to help.