Hello everyone.
Everyday I run a report that integrates into a database. Since the file was different everyday, I had the macro stored in the personal workbook.
I am now trying to move the macro to the database, so that the personal workbook would only have the code to call the macro in the database.
My problem is that the report name can be different everyday. Without having a fixed report name, I was not able to figure out how to define it as a workbook variable since now the "main" macro is in a different location.
Does anyone have any suggestion on how I can store the report as a variable or some other idea?
Thank you for your help,
Rui
Everyday I run a report that integrates into a database. Since the file was different everyday, I had the macro stored in the personal workbook.
I am now trying to move the macro to the database, so that the personal workbook would only have the code to call the macro in the database.
My problem is that the report name can be different everyday. Without having a fixed report name, I was not able to figure out how to define it as a workbook variable since now the "main" macro is in a different location.
Does anyone have any suggestion on how I can store the report as a variable or some other idea?
Thank you for your help,
Rui