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

Closed
salim - Oct 12, 2015 at 03:33 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Oct 20, 2015 at 04:28 PM
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 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 12, 2015 at 03:21 PM
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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766 > Salim
Oct 16, 2015 at 01:32 PM
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
Salim > rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022
Oct 16, 2015 at 02:08 PM
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
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Oct 16, 2015 at 02:15 PM
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
Salim > rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022
Oct 16, 2015 at 02:52 PM
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