I have an Excel spreadsheet which gets its data from an external data source (a SQL database). The SQL query used pulls all data from a table which is within a date range. At the moment this date range is assigned by manually updating the query.
Once the data is on the spreadsheet, I have a macro which updates the sheet, and refreshes the database query thus presenting up-to-date information.
I'd like to use VBA to prompt the user for a date range, so that they don't get a chance to edit the whole query. The dates they enter would be inserted into the SQL query and then run against the database.