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

Excel /VBA - Copy data from one work book to another
Transfer data from one excel worksheet to another automatically - Guide
Number to words in excel formula without vba - Guide
Vba case like - Guide
Tmobile data check - Guide
Google book downloader mac - Download - Other

1 response

Answer 1 / 1

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?

Salim
Oct 12, 2015 at 09:00 PM

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

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?

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

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?

Similar discussions

Unlock safe folder without losing any data

How To Fix Mint Mobile Data Not Working?

Similar discussions

Subscribe To Our Newsletter!