Hi-
I am looking to export data I have in an excel worksheet to an Access database using VBA. I need this to be automated. There are three worksheets in my workbook. They contain text boxes and perform calculations through VBA. The third worksheet takes the data from the text boxes and make a plain old spreadsheet out of it. What I want is when the user clicks on a save button, I want to send the data in that third spreadsheet to an Access Database. I am trying to figure out exactly how I should do this. Actually if anyone knows how to get the data directly from the text boxes on the spreadsheet that would be even better. Right now I just created the third sheet with the data cause I figured it would be easier to export the data like this. If anyone has any code or suggestions of where I can look, I would really appreciate it.
Thanks,
Aryana
