0
Good morning,
need to select data from a file Excel copy, open a file in Google Drive and paste the data.
Sub ActualizarDrive()
'Selecionar Ficheiro
Windows("Lojas_Pendentes_CCTV.xlsx").Activate
'Seleciona dados a cópiar
Sheets("Lista Loja").Select
Range("B3:T3").Select
Range(Selection, Selection.End(xlDown)).Select
Selection.copy
'Abrir Drive e colar dados.
Shell ("C:\Program Files (x86)\Google\Chrome\Application\Chrome.exe -url https://docs.google.com/spreadsheets/xxxxxxx")
Range("B2").Select
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=True
End Sub
It’s working fine until you open the Drive but then I can’t select any cell and paste.
What needs to be done to achieve this step?
Thank you.
I recommend using the google spreadsheets API or for interactions with windows, there is the Autoit or for web crawling on Chrome, there is Selenium.
– danieltakeshi
@danieltakeshi thank you for your directions. As I do not know anything of VBA and the other applications I have not solved the problem but I will continue to read about them try to understand how to do and in case some doubt arises I put here. Thank you again.
– R.Galamba
@danieltakeshi thanks again. I will "study" the Selenium and try to install the Selenium VBA (company pc must need admin authorization).
– R.Galamba