Ir ao conteúdo
  • Cadastre-se

Nicchon Sanchez Pinto

Membro Júnior
 Perfil  Explorar Conteúdo

  • Posts

    3

  • Cadastrado em

  • Última visita

 Tipo de conteúdo 

posts postados por Nicchon Sanchez Pinto

    Como trocar de tela de um Excel para outro

    em Microsoft Office e similares

    Postado

    @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

    Como trocar de tela de um Excel para outro

    em Microsoft Office e similares

    Postado

    @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


     

    Como trocar de tela de um Excel para outro

    em Microsoft Office e similares

    Postado

    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..

     

     

     

Sobre o Clube do Hardware

No ar desde 1996, o Clube do Hardware é uma das maiores, mais antigas e mais respeitadas comunidades sobre tecnologia do Brasil. Leia mais

Direitos autorais

Não permitimos a cópia ou reprodução do conteúdo do nosso site, fórum, newsletters e redes sociais, mesmo citando-se a fonte. Leia mais

Mais

×
×
  • Criar novo...