Sorry I am not clear in my prev post. I want this done by a command button in Access. So I need VBA code so that when I click on the button, It will
1) Read an existing excel file
2) Put some values in some certain cell
3) Then Save the excel file in a different name (like save as).
I have an Access database. Now I want to export the data of a table in the database to excel sheet in pre-defined format. e.g. i want that in the first row of the excel file, there is a heading called "Report". In the second row, there should be column header like "Name", "Age", "Gender". Also...
Why on mouseover action is not listed?
well, i saw chris's work. that's fantastic. But my question is whether "on mouseover" action is not available in ms access2000 or i failed to find it??