Nicchon Sanchez Pinto

Eae pessola, beleza? Então, minha pergunta é basicamente o titulo mesmo kkk, alguém aí sabe me informar como bloquear teclado e mouse com VBS ou Batch ? Agradeço desde já..

@Edson Luiz Branco TRABALHO 23-08.xlsxPROTOCOLO DE ENTREGA MODELO 1 EM EXCEL.docx.xlsx, São 2 arquivos em excel, quero colar as informações de um no outro q é um protocolo que montei com base no protocolo q estava no Word, vou mandar as duas planilha e marcar com cores o que eu quero copiar de um e onde vou colar no outro... adicionado 46 minutos depois @Edson Luiz Branco , no caso eu queria copiar a primeira linha e colar nos devidos lugares da outra e imprimir, aí dps voltava na outra planilha copiava os dados da segunda linha, colava na outra e imprimia, e assim por diante

@Edson Luiz Branco , é porque n sei linguagem VBA kkk, e também não sei mt de VBS também, teria como escrever o que eu devo escrever dentro do Script para eu colar lá kkk?, vou colar meu script aqui e marcar o ObjShell.WindowSwitch de vermelho, porque o script ao todo tá: COLUNA01 = MSGBOX("PRONTO ?", 4+64, "COLUNA 01") IF COLUNA01 = VByes THEN MyString = "yes" set wshshell = wscript.createobject ("wscript.shell") set objshell = createobject ("shell.application") 'cresp wscript.sleep 3000 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "^c" wscript.sleep 1000 objshell.windowswitcher wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{ENTER}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "^v" wscript.sleep 1000 objshell.windowswitcher wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{ENTER}" 'GP e SL wscript.sleep 1000 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "^c" wscript.sleep 1000 objshell.windowswitcher wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{ENTER}" wscript.sleep 1000 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "^v" wscript.sleep 1000 objshell.windowswitcher wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{ENTER}" 'PARA wscript.sleep 1000 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "^c" wscript.sleep 1000 objshell.windowswitcher wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{ENTER}" wscript.sleep 1000 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "^v" wscript.sleep 1000 objshell.windowswitcher wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{ENTER}" 'Lider de área wscript.sleep 1000 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "^c" wscript.sleep 1000 objshell.windowswitcher wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{ENTER}" wscript.sleep 1000 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "^v" wscript.sleep 1000 objshell.windowswitcher wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{ENTER}" 'TITULAR wscript.sleep 1000 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "^c" wscript.sleep 1000 objshell.windowswitcher wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{ENTER}" '1º protocolo wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "^v" '2º protocolo '5 wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" '10 wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" '15 wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" '20 wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" '24 wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "^v" '2º protocolo '5 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" '10 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" '15 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" '20 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" '25 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" '30 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" '35 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" '36 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "+{DOWN}" wscript.sleep 250 wshshell.sendkeys "+{DOWN}" wscript.sleep 250 wshshell.sendkeys "+{DOWN}" wscript.sleep 250 wshshell.sendkeys "+{DOWN}" wscript.sleep 250 wshshell.sendkeys "+{DOWN}" wscript.sleep 250 wshshell.sendkeys "+{DOWN}" wscript.sleep 250 wshshell.sendkeys "+{DOWN}" wscript.sleep 250 wshshell.sendkeys "+{DOWN}" wscript.sleep 250 wshshell.sendkeys "+{RIGHT}" wscript.sleep 500 wshshell.sendkeys "^c" '5 wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" '10 wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" '15 wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" '20 wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" '25 wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "{DOWN}" wscript.sleep 500 wshshell.sendkeys "^v" '5 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" '10 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" '15 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" '20 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" '25 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" '30 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{UP}" '31 wscript.sleep 500 wshshell.sendkeys "{UP}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 5000 wshshell.sendkeys "^p" wscript.sleep 1000 wshshell.sendkeys "{ENTER}" wscript.sleep 1000 objshell.windowswitcher wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{ENTER}" wscript.sleep 1000 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" wscript.sleep 1000 wshshell.sendkeys "^+{RIGHT}" wscript.sleep 250 wshshell.sendkeys "^+{RIGHT}" wscript.sleep 250 wshshell.sendkeys "^+{RIGHT}" wscript.sleep 500 wshshell.sendkeys "%" wscript.sleep 500 wshshell.sendkeys "c" wscript.sleep 500 wshshell.sendkeys "r" wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{DOWN}" wscript.sleep 250 wshshell.sendkeys "{RIGHT}" wscript.sleep 250 wshshell.sendkeys "{RIGHT}" wscript.sleep 500 wshshell.sendkeys "{ENTER}" wscript.sleep 500 wshshell.sendkeys "{LEFT}" ELSE MyString = "no" wscript.sleep 1000 MSGBOX "OPERAÇÃO CANCELADA", 0+64, "COLUNA 01" END IF

Eae galera, td bom? Sou novo com VBS, e estou com uma dúvida sobre como abrir um arquivo usando o VBS, tipo o START do Batch, tava precisando fazer um VBS para abrir um Batch q cria um VBS e executa ele kkk, é uma longa história, aí n sei se usa o WshShell.Run, e mesmo se for ainda não sei como se utiliza o WshShell.Run kkkk, não sei o que digitar dps disso e como digitar, tipo no Batch q pra eu abrir um aplicativo tipo o Windows Explore eu teria que digitar START IEXPLORE.EXE, ou a calculadora e seria START CALC.EXE, entendeu? Agradeço desde já...

Eae galera, beleza? Tô com uma dúvida aqui sobre VBScript, sou novo com isso... Tô apanhando feio aqui tem um tempão pra VBS kkk Queria mudar de uma tela pra outra usando VBS, porém com um bloco sendo copiado para eu colar na outra planilha, aí tentei: wshshell.sendkeys "^%{TAB}" e não deu certo, dps tentei também: objshell.windowswitcher wshshell.sendkeys "{DOWN}" wshshell.sendkeys "{ENTER}" e também n deu certo... Ele só deu certo quando não tava copiando nada da outra planilha, mas quando fazia CTRL C antes de mudar de tela ele fazia o objshell.windowswitcher mas ia pra mesma tela... Se alguém puder me ajudar com isso aí, ou me dar uma outra alternativa para fazer esse mesmo processo de copiar um bloco (ou mais) mudar de planilha e colar..