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