MrExcel.com - Your One Stop for Excel Tips & Solutions

Template wizard with data tracking

Posted by Henry on April 16, 2001 9:15 PM

In trying to create a macro that will save the information entered into the template as an Access database record. When I manualy save the database, a window popups asking if I wish to save the record.

When I use the "ActiveWorkbook.Save" command within a macro it saves the template as a .xls file, does not popup a window, and does not update the databse.

My ultimate objective is to save the template in order to create the new record in the databse and then reopen the template to create another record.

Thanks

Henry

Posted by Dave Hawley on April 16, 2001 9:33 PM


Hi Henry

Ty either of these two methods.

ActiveWorkbook.SaveAs FileName:= _
"C:\OzGrid\Book1.dbf", FileFormat:=xlDBF4 _
, CreateBackup:=False

...Or


Application.Dialogs(xlDialogSaveAs).Show "Book1.dbf", 7

Dave

OzGrid Business Applications

Posted by Henry on April 16, 2001 9:47 PM

Thanks dave,

My original post was was misleading. What I actually want to do is not save the template as a database file but write the data entered into the template as record in an Access file named OT.mdb

When I refer to saving the template, it is only because that is the only way I can write the data as a record in the database and then use the template again.

Henry