I'm using Access 2007. I have a DB which exports and imports excel sheets. I have 7 sheets per workbook and i can read and write them fine. I also have cells (or ranges) being locked and the sheets are protected, etc. Think i should post my module (or a simple version of my DB) here when I'm done with it.
The questions I have are:
- Can I create combo boxes on my excel sheets, from which the users should select an option from. (and how???)
- I would also like to validate the entries into the excel sheets, made by the remote users. As in ensure that the date and time entries are correct, etc.
- I'm developing this in Access 2007, I have the full version of Office on my PC, which means that the Excel workbooks being created are .XLSX files, Is there a way to create proper .XLS files. I was creating .xls workbooks, I found that Excel would open them fine, but i was getting an error message (can't remember what it was now) but any message coming up is not good.
These are the final 'bells and whistles' for the DB