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" <(E-Mail Removed)> schreef in bericht
news:383F75CF-25F7-44C1-BC08-(E-Mail Removed)...
> 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" <(E-Mail Removed)> schreef in bericht
> news:383F75CF-25F7-44C1-BC08-(E-Mail Removed)...
> > 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.
>
>
>