Excel /VBA - Copy data from one work book to another

Closed

salim - 12 Oct 2015 à 03:33
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 20 Oct 2015 à 16:28

Hello All,

Can you please help me to make VB program for an excel file.
Basically I want to copy the data from an excel work book which is located in LAN network and paste into another book which is located in non network(my desk top).

If you can give me a model file , please use below information.

Source file name: plant data
Destination file name: daily data
area to copy: please put any range(I will change later on)
area to paste: please put any(I will change later on)
File Path: please put a model, (I will change later on)

Please ask me if you need in put for the same

- - @***

deleted by moderator

I would be very grateful if you could help me on this,

Best regards,
Mohammed Salim

Vba copy data from one workbook to another
How to copy data from one excel sheet to another - Guide
How to copy data to another workbook: using VBA - Guide
Excel move data from one sheet to another - Guide
Tmobile data check - Guide
Find vba - Guide

1 response

Réponse 1 / 1

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
12 Oct 2015 à 15:21

Have you tired to use macro recorder Salim?

Salim
12 Oct 2015 à 21:00

Hi Rizvisa I ,

No I haven't, are u believe macro recorder will solve this? Can you give me the same?

Best regards,
Salim

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766 > Salim
16 Oct 2015 à 13:32

Salim, recorder is available in excel and is used to record your action. it creates a macro that can be used as is or modified to make it work for more cases

Salim > rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022
16 Oct 2015 à 14:08

Hi rizvisa1,
Actually the source(which is in network share folder) is updating daily by some other person, what I am looking is I need to update my file(target) daily by copying some cells without open the source file. So this can possible by macro record?

rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 766
16 Oct 2015 à 14:15

depends on what you want to do.
one way could be that source file has a formula that links to your workbook. so all depends

Salim > rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022
16 Oct 2015 à 14:52

since source file is the master file which ideally should not be disturbed. So my only option is to play in target file. Do u have suggestions on this situation?

Similar discussions

Copying data from one Excel sheet to another.

Copy Worksheet to another Workbook (unopened)

Using VBA Code to extract data from a website

Hosted app data will not clear

Unlock safe folder without losing any data

Similar discussions

Subscribe To Our Newsletter!