I'm having some problems getting the code right, so I'll give points for whoever can write it for me.
I'd like some code behind an Access Button that will connect to an existing Excel File, check to see if a particular sheet is already present in the Excel file, and create it if it doesn't exist, or overwrite it if it does exist. The sheet I'm adding can just be blank, as I'll then add code to write values to the cells. Then, save the Excel changes and drop the connection to the sheet.
I don't want to see any messages asking "Are you sure you wish to overwrite the sheet", etc.
Thanks, and Good Luck,
I'll award an additional 100 points to anyone who can direct me to a web site with shows some good examples of writing access code to interact with Excel Files. None of the text books I've read give any instruction on this...