Good morning.
I am linking to an excel files, which a range of headers are dates. These dates change every week. I have not been able to find a solution which works, which would allow me to "refresh" the headers names automatically.
I would also need the underlying queries, forms, and reports to be dynamic as well, which would be used against the linked table.
Any thoughts on how to process this would be appreciated. This excel file feeds other excel reports, so I need to be able to run in both excel and access until I incorporate all the excel tools we use into the MS Access database. Otherwise, I would just do away with the excel files at once and import it all into Access.
I should add, the data which feeds the Excel file, comes from our MRP System and a data extract which is pulled every week and automatically updates the excel file.
Thank you in advance!