I needed a code wherein on a click of a button, access opens a specified excel file, (copies a segement of data from the Excel file and save it at another location as a new file) and then set focus back to Access
The line in italics is taken care by Excel macros.
I tried the Code above with...