| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Insert, copy, update, delete records through VBA
Since it is not practical for me to open the excel file always
???? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Cannot Move, Copy, Insert, Rename, or Delete a Worksheet in Any Wo | Excel Discussion (Misc queries) | |||
| Delete records when certain records have duplicate column data | New Users to Excel | |||
| Block copy/insert of 5 rows, then update formula below? | Excel Worksheet Functions | |||
| check box, copy / paste or insert / delete row | Excel Worksheet Functions | |||
| cut and delete a row then insert and copy | New Users to Excel | |||
Linear Mode
