Going Cross Eyed
New Member
- Joined
- Oct 14, 2002
- Messages
- 42
Any help on this would be much appreciated.
I have set up a template and excel sheet with the template wizard. When you click on Save you get a pop up asking whether you want to add a new record to the database. All OK so far!
BUT I want to perform the 'Capture Data in Database' function in a macro and I can't figure this out. (The recorder won't pick it up). I have seen this done in a macro in the 'spreadsheet solutions' expense forms and so on... can anyone tell me how this is done?
I have set up a template and excel sheet with the template wizard. When you click on Save you get a pop up asking whether you want to add a new record to the database. All OK so far!
BUT I want to perform the 'Capture Data in Database' function in a macro and I can't figure this out. (The recorder won't pick it up). I have seen this done in a macro in the 'spreadsheet solutions' expense forms and so on... can anyone tell me how this is done?
