klste@hotmail.de |
Open and edit external Excel files with flexible mask. Excel VBA
This program opens and edits external Excel files from a flexible mask.
In each spread sheet in an open Excel file, you can enter data from row 2 to row 10 000, from column 1 to column 92, and the navigation range is 100 columns and 10 000 rows.
The program can handle such a database consisting of no more than 13 columns, 1 row for headings and 9 999 rows for data.
First, the cell with the first heading that is chosen as the beginning of the database is activated.
In the "Data type" frame, each column with a heading is assigned a data type: text, number, date or time. Editing items are not displayed for columns without a heading.
In the "Enter" frame, data is entered into each selected row.
In the "Search" frame, the selected search term is searched for in the selected column and the program creates a list of line numbers in which the search term was found in a combo box.