Hello...I would like to find a way in Excel to create a button that will copy from a textbox in an open MS Access form into an Excel field. Lets say for arguments sake the location of the database is C:\Test\Test.accdb, the form is called TestForm1 and the textbox is named TestTextBox1 and I want it pasted to Sheet1, A1 in Excel. So basically I will have this database and form open and ill want to then click a button in excel that activates a macro that copies the textbox. I know this is possible somehow because nothing is impossible lol. Let me know! Thanks!
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Paste from MS Access into Excel
- Thread starter Ace71425
- Start date
