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

Closed
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
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




1 reply

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Have you tired to use macro recorder Salim?
0
Hi Rizvisa I ,

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


Best regards,
Salim
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768 > Salim
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
0
>
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020

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?
0
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
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
0
>
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020

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?
0