DCrake
07-14-2010, 02:37 AM
I Access 2003 I can quite easily customise a menu and add custom mnu items to them which inturn call vba macros to open forms, etc. Now my intracate knowledge of 2007 is somewhat limited. It even took me a while to find out how to get access to vba in Excel.
So my question is: Is it as easy to do in 2007 as it is in 2007? I fear not. Anyway if someone has any examples or advice I would appreciate it.
The basic concept is that a email arrives with a workbook attachment that contains one worksheet with the desired data. I then go to the Data ribbon and select a custom menu item. The menu action will call a function that opens up a mdb using DAO and iterates through the worksheet row by row validation the cell contents and using Rs.AddNew append the records to Access. All this I can accomplish as I have done this in 2003, The main isssue is the customisation of the ribbon.
So my question is: Is it as easy to do in 2007 as it is in 2007? I fear not. Anyway if someone has any examples or advice I would appreciate it.
The basic concept is that a email arrives with a workbook attachment that contains one worksheet with the desired data. I then go to the Data ribbon and select a custom menu item. The menu action will call a function that opens up a mdb using DAO and iterates through the worksheet row by row validation the cell contents and using Rs.AddNew append the records to Access. All this I can accomplish as I have done this in 2003, The main isssue is the customisation of the ribbon.