I have an excel sheet that I keep tennis game difference results in.
I also have the actual results recorded in Access.
What I wish to do from Access is to:
1. Import the sheet from excel into Access...this I have no problems with.
2. Manually input a teams results into Access.
3. Update the Excel sheet with the updated teams results.
I have no idea on Excel automation, can somebody give me a head start please.