Transfer data from one workbook to another in different folders via vba.

[MS_1977]

I'm having trouble with a vba code, to copy data from one Workbook to another, in different folders. Would there be any way to accomplish this process via code?

 

[mumps]

The answer to your question is "Yes". However, we need to know the sheet name and range of data you want to copy. We also need to know the file name , sheet name, paste location and full path to the folder containing the destination file.

 

[MS_1977]

A resposta para sua pergunta é sim". No entanto, precisamos saber o nome da planilha e o intervalo de dados que você deseja copiar. Também precisamos saber o nome do arquivo, o nome da planilha, o local da colagem e o caminho completo para a pasta que contém o arquivo de destino.

Caxumba, as planilhas então na Rede aqui na CIA, em pastas diferentes, mas a minha expectativa era abrir a palnilha destino e colar nela, o problema que ocorre o erro desmostrado no anexo.

 

[mumps]

I'm sorry but I don't understand Spanish. Also, it would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

 

[MS_1977]

I'm sorry but I don't understand Spanish. Also, it would be easier to help if you could use the XL2BB add-in (icon in the menu) to attach a screenshot (not a picture) of your sheet. Alternately, you could upload a copy of your file to a free site such as www.box.com or www.dropbox.com. Once you do that, mark it for 'Sharing' and you will be given a link to the file that you can post here. Explain in detail what you want to do referring to specific cells, rows, columns and sheets using a few examples from your data (de-sensitized if necessary).

Caxumba, the spreadsheets then on the Network here at the CIA, in different folders, but my expectation was to open a target flap and paste it, the problem that occurs with the error shown in the attachment.

 

[MS_1977]

Caxumba,

Follow Google Drive link

VBA_2021 - Google Drive

drive.google.com

 

[mumps]

The link you posted takes me to the Google Drive sign-in page. I need a direct link to your file.

 

[MS_1977]

O link que você postou me leva à página de login do Google Drive. Preciso de um link direto para o seu arquivo.

Could you give me an email to add to the google drive?

 

[mumps]

You actually don't need my email address. You have have to create a Google Drive account for yourself to be able to use it.

 

[MS_1977]

You actually don't need my email address. You have have to create a Google Drive account for yourself to be able to use it.

Follow the link

VBA_2021 - Google Drive

drive.google.com