Linking data from one file to another on a weekly basis using a ma

[Red Neck]

Hello,

I want to link data from one file to another using a macro / visual basis. I
am hoping to have a drop down in which I can select the week number I want to
pull into me 'master file'

I would have one master file and 52 weekly files. The macro should allow me
to use the drop down menu and select from whatever one of the fifty two weeks
in the year.

I would apprecate any help with this.

Regards

 

[Vincent Johns]

Hello,

I want to link data from one file to another using a macro / visual basis. I
am hoping to have a drop down in which I can select the week number I want to
pull into me 'master file'

I would have one master file and 52 weekly files. The macro should allow me
to use the drop down menu and select from whatever one of the fifty two weeks
in the year.

I would apprecate any help with this.

Regards

Having to maintain 52 separate files seems kind of beastly. Can you
perhaps set up a means of importing the contents of the weekly files
into an Access Table, from which you could then select the records
related to the desired week? That's how I'd do it, unless I couldn't
for reasons of size or something similar.

Of course, using VBA, you can compute the name of the weekly file you
wish to use, then import its contents at that time, but it seems like a
lot of extra work.

-- Vincent Johns <[email protected]>
Please feel free to quote anything I say here.