I have created an xlt file that will add a new record to a database. I would like the whole process to be "hidden" in a macro. I have placed a button on the spreadsheet that will pull up the form...now I want a button on the form itself that will save the new record into the database without showing the built in Excel dialog box that asks whether they want to create a new record (I want it to default to always create a new record) and I also want to avoid showing the "Save As" dialog box that appears. Is there any way to do this?
Is there anyplace where I can see the code from the built in Excel features (such as the one the shows the dialog asking whether or not to create the new record?
Thanks in advance for your help.