Insert, copy, update, delete records through VBA

  • Thread starter Thread starter Raiju
  • Start date Start date
R

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
 
Update:

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


Add:

Sub Macro1()
Workbooks.Add
End Sub
 
Back
Top