Given:
Table1:
Last Name, First Name, Dollar, Forms, Execute
Doe John 56 Form A, Execute
Buck Susan 33 Form B, Execute
List 1 is defined by region name for data validation in Table1.Forms column:
Form A
Form B
Form A and B are different forms made on Excel Spread Sheet.
Table1.Forms column is a drop down list linked to List 1
Table 1.Execute column has Text "Execute"
From the drop down selection box in column Forms, user specify the type of form (A or B) they want to be populated automatically then select the last column "Execute" in the corresponding row.
[I do not want to use hard coded column # to test which column is used but want to use Table 1 column's name "Execute". I do not know the syntax to do this.
I need help in VB code for the following:
Code behind supposed to check if a folder by the last name, first Name already exists in c:\Excel.
If the folder doesn’t exist then
a) create a folder by first name, copy blank form A or B from existing templates,
b) fill in Row1, Col1 of the blank form with the last name (either Doe or Buck) whichever Push Button is pressed.
c) save the Excel file workbook (form A or B) by the last name in the newly created corresponding folder.
If a folder by the last name, first name already exists then just open the existing file.
In the same problem but a different issue:
How can I use push button control in the last column "Execute"? I would need row and column address of the push button instead of pushbutton #.
When I use push button (control) in the last column then it is not being copied automaticaly when the table grows. Any idea how to make the control automaticaly copied to the new rows as the table grows?
Bookmarks