Hi
I have an Excel sheet that runs an Access sheet query to get the data from our enquiries database.
When the vba runs from excel, it opens access - runs query - pops up a 'Start date' box - then pops a 'End date' box up - then returns the data between these dates - selects all the data - closes query & access - selects A4 on excel - pastes data into excel.
I would like to be able to automatically copy the start and end dates from excel cells (C1 & C2) and paste them into the start and end date boxes on access.
Is there a way to do this?
Here is the code I have that.
Kieran
I tried adding something like this, but it won't paste in the box.
Bookmarks