Does anyone know of a way to copy from a workbook that is constantly updated
everyday, the thing a new workbook is created everyday based on a date, what
I would like to do is to create a macro that would copy the data from the
most recent workbook. For instance if todays workbook to copy from is labeled
2008-0218, then I would like it to copy all the data within that to a master
workbook, then the next day comes and a new workbook is created labeled
2008-0219, I want to copy from that one as well and it goes on everyday. I
don't want to delete the data that is already there, just to append to whats
already there, so if anyone know's of a way to do this, any help would b
appreciated.

Hi!
I imagine you could search up from the bottom of each worksheet until you
find a row that contains content (this is easier/quicker if you know
something is inside the first 20 columns or so). Then you can paste in the
last row without content.

Use dir to find the newest workbook in the folder.

HTH,
Birgit


"drinese18" schreef in bericht
...
Does anyone know of a way to copy from a workbook that is constantly
updated
everyday, the thing a new workbook is created everyday based on a date,
what
I would like to do is to create a macro that would copy the data from the
most recent workbook. For instance if todays workbook to copy from is
labeled
2008-0218, then I would like it to copy all the data within that to a
master
workbook, then the next day comes and a new workbook is created labeled
2008-0219, I want to copy from that one as well and it goes on everyday. I
don't want to delete the data that is already there, just to append to
whats
already there, so if anyone know's of a way to do this, any help would b
appreciated.

Do you by any chance know how to code it probably, because I want to have it
programmatically do so

"Birgit" wrote:

Hi!
I imagine you could search up from the bottom of each worksheet until you
find a row that contains content (this is easier/quicker if you know
something is inside the first 20 columns or so). Then you can paste in the
last row without content.

Use dir to find the newest workbook in the folder.

HTH,
Birgit


"drinese18" schreef in bericht
...
Does anyone know of a way to copy from a workbook that is constantly
updated
everyday, the thing a new workbook is created everyday based on a date,
what
I would like to do is to create a macro that would copy the data from the
most recent workbook. For instance if todays workbook to copy from is
labeled
2008-0218, then I would like it to copy all the data within that to a
master
workbook, then the next day comes and a new workbook is created labeled
2008-0219, I want to copy from that one as well and it goes on everyday. I
don't want to delete the data that is already there, just to append to
whats
already there, so if anyone know's of a way to do this, any help would b
appreciated.