Insert, copy, update, delete records through VBA

[Raiju]

Hi,

I have an excel'07 database of employees where I have to add, update, delete
records very often. Since it is not practical for me to open the excel file
always, I wish to have a macro, which can help me to enter, update or delete
records from an excel file and even generate report of employees based on the
different criteria.

It will be a great help if any one can help me with this.

Regards,
Raiju

 

[Philosophaie]

Update:

Sub Macro1()
Workbooks.Open Filename:= "C:\Path\file.xlsm"
End Sub


Add:

Sub Macro1()
Workbooks.Add
End Sub

 

[Philosophaie]

Also to delete:

Sub Macro1()
Kill c:\Path\file.xlsm
End Sub

 

[rumkus]

Since it is not practical for me to open the excel file always

????