Hey y'all, I am working on a rate validation (comparing insurance rates for medical, dental, vision insurance to a rate sheet). My company really likes it, and wants to be able to use it for future years, and more clients. I am drawing the rates that are calculated for each participant through a query against our production, or real life data, database. In the future, we will need to run this query against test databases, and using different activity dates/employment status dates. This query that I am using is stored in the SQL editor page of the data input function (I pull data through an in-DB connection). Does anyone know a way I could configure a macro so that people can simply input their database name and the effective date they want to query by, then click run?
Summary: Need a "so easy a caveman could do it" way to replace a database string and a date string within a query stored in SQL editor, preferably not using the Dynamic Input function because that will require storing the SQL logic in an excel document that I think will get lost or corrupted over time
