Hello ... I'm pretty new here, and I'm amazed by the VBA geniuses in here! If I could ask for your assistance, it certainly won't go unnoticed.
Here's what I want to do with an Access Data Base:
Thanks to some help kindly provided, I was able to create excel files out of a "mother file", which generates files in a certain folder with an established format, like this: "M-12345678 1234", now, what I would like to do with Access is to create a data base which can screen those files, find some dates that are contained in a sheet within those files and from those, to be able to generate a schedule according to the dates in some of those cells (date cells), also, according to those files, to look up or screen the files that match certain criteria, such as date, code or some other data that all those files share in certain cells.
May I respectuflly ask some help, ladies and gents?
Bookmarks