Add,Edit and Delete

epl_leicester
04-03-2003, 12:34 AM
Hi everybody, I have totally no idea how to add, edit and delete a data on excel using VB? :confused: Please provide me any solution if you have.... Tankz

italkid
04-03-2003, 04:26 AM
Dim XlApp As Excel.Application
Set XlApp = New Excel.Application

XlApp.Visible = False '(or True)
XlApp.Workbooks.Open Filename:=App.Path & "\Yourfile.xls"

With XlApp.Workbooks("Yourfile")
'your code > from here you can do everything you want

With the reply of JordanChris on your other tread you got started so,
now you could use your Excel macrorecorder to get the code you need to Edit,Delete,Copy,Paste and so on.
Its the best and easyest way to learn.
Excel offers us with the macrorecorder a great tool so you could better make use of it.
And of course a search on this forum could give you a hand to.
If you still got a problem later on just post a tread with your specific question/problem.

Kind regards

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum