Thanks nilem. OK.
Originally Posted by nilem
Create a new XLSX file and put some dummy data into the first 4-5 rows of column A & column B. Name the sheet "employer10" and save and close the workbook. (This is a dummy workbook that will be used to test the code).
Now create a new XLSM.
Copy the code below into a new form. Add a Listbox and a Command button to the form. The Command button should be called OKButton.
You will need to add a public const for sServerFolderProgram & sServerFileDatabaseExcel. The first const should point to the XLSX folder location (without the last "\") and the second const should be the filename of the XLSX file.