I have created an input file and corresponding database in excel. Sinc
I would like to use the input template as the only data entry point,
attempted to create a macro that automatically populates the databas
at the push of a button. The database population typically takes plac
in 2 steps:

step 1: save the input template file
step 2: a dialog box appears and asks the user to choose whether t
create a new database record or not.

I used macro recorder to replicate these steps, however step 2 doesn'
seem to work. When the dialog box from step two appears, the macr
recording icon actually disappears, which makes me think that it's no
actually being recorded.

Now when using the new macro, the input file is saved, but the databas
record is not added, nor do i receive a message asking whether i woul
like to create a new record.

i'm not fluent with vba, but this seems like it shouldn't be to
difficult to fix... any ideas? Thanks

--
Message posted from http://www.ExcelForum.com