Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default Transfer data from one workbook to another workbook resident inNetwork, based on Date Filters

Hi

I have a workbook RawData.xlsx in my D: Drive, containing a worksheet
"Data" which gets populated date-wise basis. It is quite a large datasheet as it contains data from 5 years ago till present and having 60 columns. The first column is the Date Field.

I would like to transfer this data to another workbook FinalData.xlsx having a worksheet "Data" which has the same field names as that of the original worksheet of RawData.xlsx.

There are two issues that I am clueless about:

First, this FinalData.xlsx is resident on a network computer (Computer name : Quality) under its D: Drive. So How will I be able to set the target path

Secondly each time I save the RawData.xlsx workbook, I would want to transfer those data that are 30 days old till date, from the RawData.xlsx workbook to the FinalData.xlsx workbook

I would be glad if i could get help on how to write the code for this program.


Thanks for the help

  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,182
Default Transfer data from one workbook to another workbook resident in Network, based on Date Filters

Hi

I have a workbook RawData.xlsx in my D: Drive, containing a worksheet
"Data" which gets populated date-wise basis. It is quite a large
datasheet as it contains data from 5 years ago till present and
having 60 columns. The first column is the Date Field.

I would like to transfer this data to another workbook FinalData.xlsx
having a worksheet "Data" which has the same field names as that of
the original worksheet of RawData.xlsx.

There are two issues that I am clueless about:

First, this FinalData.xlsx is resident on a network computer
(Computer name : Quality) under its D: Drive. So How will I be able
to set the target path


Have a look at how to use GetOpenFilename() OR GetSaveAsFilename()
functions.

Secondly each time I save the RawData.xlsx workbook, I would want to
transfer those data that are 30 days old till date, from the
RawData.xlsx workbook to the FinalData.xlsx workbook


How will you 'flag' data already written to target xls? Are you
actually transfering OR just copying?

Perhaps ADODB is the way to go. Here's a good start...

http://www.appspro.com/conference/Da...rogramming.zip

I would be glad if i could get help on how to write the code for this
program.


Thanks for the help


--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

---
This email has been checked for viruses by Avast antivirus software.
https://www.avast.com/antivirus

  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 37
Default Transfer data from one workbook to another workbook resident inNetwork, based on Date Filters

On Monday, August 29, 2016 at 7:59:47 PM UTC+5:30, shriil wrote:
Hi

I have a workbook RawData.xlsx in my D: Drive, containing a worksheet
"Data" which gets populated date-wise basis. It is quite a large datasheet as it contains data from 5 years ago till present and having 60 columns. The first column is the Date Field.

I would like to transfer this data to another workbook FinalData.xlsx having a worksheet "Data" which has the same field names as that of the original worksheet of RawData.xlsx.

There are two issues that I am clueless about:

First, this FinalData.xlsx is resident on a network computer (Computer name : Quality) under its D: Drive. So How will I be able to set the target path

Secondly each time I save the RawData.xlsx workbook, I would want to transfer those data that are 30 days old till date, from the RawData.xlsx workbook to the FinalData.xlsx workbook

I would be glad if i could get help on how to write the code for this program.


Thanks for the help


Yes. that is another issue . Only that data which is 30 days old till date will be copied and pasted in the FinalData.xls. So that means that the program will need to flag from which row in the FinalData.xls will the data be overwritten.

Any help on this ? Thanks
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
transfer data from one workbook to another. Michelle Excel Programming 0 April 6th 09 07:26 PM
how to transfer data from one workbook to another with VB Dan Worley Excel Programming 5 August 2nd 08 08:09 AM
How to transfer data from one workbook to another via VBA Adnan Excel Discussion (Misc queries) 0 August 1st 08 06:42 PM
Transfer data from one workbook to another workbook based on a key Luther Excel Programming 2 September 15th 07 04:32 AM
Transfer data from one workbook to a form in another workbook NCSooner63 Excel Programming 0 May 11th 07 06:42 PM


All times are GMT +1. The time now is 09:48 AM.

Powered by vBulletin® Copyright ©2000 - 2023, Jelsoft Enterprises Ltd.
Copyright 2004-2023 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"