Mister Wayne
New Member
- Joined
- Mar 30, 2017
- Messages
- 3
I have an automated (VBA) Excel 2007 sheet to allow employees to enter parts request information.
When they are finished, they click a <SAVE> button which does the following:
1. Saves the file by a specific filename based on user data entered in several cells.
2. Sends me an email with pertinent information so I can process the order.
I would like to add code in the <SAVE> event which would also add a new row in the table of an Access data base (not opened-if possible) and copy specific cells information.
It would always be the same cells, but not necessarily in the same row/column. The database table would always contain the same column information from the same cell.
I.E. "E7" = name; "E8" = user's email address; "E9" = date; "E10" = Customer's name; "E11" = Job number.
I know this example has contiguous cells, but there are more I didn't include and I would like the flexibility of choosing by individual cell as this is a new venture and I may not always have any contiguous cells.
I'm fairly handy using VB code but the concept is foreign. I used the Microsoft CDO object to send the email.
Any help appreciated!!
Thanks so much,
Mister Wayne
When they are finished, they click a <SAVE> button which does the following:
1. Saves the file by a specific filename based on user data entered in several cells.
2. Sends me an email with pertinent information so I can process the order.
I would like to add code in the <SAVE> event which would also add a new row in the table of an Access data base (not opened-if possible) and copy specific cells information.
It would always be the same cells, but not necessarily in the same row/column. The database table would always contain the same column information from the same cell.
I.E. "E7" = name; "E8" = user's email address; "E9" = date; "E10" = Customer's name; "E11" = Job number.
I know this example has contiguous cells, but there are more I didn't include and I would like the flexibility of choosing by individual cell as this is a new venture and I may not always have any contiguous cells.
I'm fairly handy using VB code but the concept is foreign. I used the Microsoft CDO object to send the email.
Any help appreciated!!
Thanks so much,
Mister Wayne
