Hi All,

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.

To give a little background, I'll have the DB running on 1 PC on the network, and there will be remote users, the Excel workbooks are created to a network drive for the remote users to enter information (data). Their PCs will NOT have any version of Access (I've asked for the runtime version to be loaded, but basically told no... by IT) The remote users have Office 2003 on their PCs, but i couldn't be garuanteed that they all have the patch to open .XLSX files like some of our computers have.

These are the final 'bells and whistles' for the DB

Thanks