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
Add,Edit and Deleteepl_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