Insert, copy, update, delete records through VBA
 

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

Insert, copy, update, delete records through VBA
 

Update:

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


Add:

Sub Macro1()
Workbooks.Add
End Sub




"Raiju" wrote:

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

Insert, copy, update, delete records through VBA
 

Also to delete:

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

"Philosophaie" wrote:

Update:

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


Add:

Sub Macro1()
Workbooks.Add
End Sub




"Raiju" wrote:

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

Insert, copy, update, delete records through VBA
 

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

????