Macro that opens access and auto fills input boxes before exporting.

[CJPHX]

Good Afternoon All,
I am currently working on a macro that updates daily performance numbers. The data itself is housed in differnet tables in different access databases. It is very time consuming to get this data from the different areas and fill in the report. I have a macro that opens access and runs the different query's which export to excel sheets then updates the report. The problem I have is the query's this information is taken from, pulls from a table that houses historical data for the whole year. I have prompts on the query that ask you for a date range you want the data for. Right now when I run the macro it opens access you enter the date ranges, it then exports the data and closes access. The issue is that it runs 6 - 7 different query's which means you would have to enter your date range 6-7 times. Is there a way to have excel fill in those input boxes for the user without them having to type it in themselves. The date range would always be the first of the month to the current day. Which I have code for in a seperate macro.

Please Login or Register  to view this content.

I would like this to appear at the begingin of the macro that pulls the access data so that it fills in the first box(which asks for "Start Date") with the "firstmonth" string, and then the second box(which asks for the "End Date") with the "filedate" string.

Please Login or Register  to view this content.

[CJPHX]

Bumping - No response.