View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Lee Lee is offline
external usenet poster
 
Posts: 2
Default Reference using Excel with VB.NET

Thank you very much for the help and suggestions. They
were very helpful.
Regards,
Lee
-----Original Message-----
I believe, once you get your reference to the excel

application, you just
use the Excel object model to do the rest

oxlApp.Workbook.Open "C:\my Documents\Myfile.xls"
oxlApp.Activesheet.Range("A1:B20").Copy Destination:= _
oxlApp.ActiveSheet.parent.Worksheets("Sheet3").Ran ge

("C32")

There is a lot of sample code in the Knowledge Base

You can look at this page as a start as well:

http://msdn.microsoft.com/office/understanding/vsto/
Visual Studio Tools for the Microsoft Office System

It is all about .Net and Office.

--
Regards,
Tom Ogilvy


Lee wrote in message
...
I am having a heck of a time trying to learn how to
manipulate Excel from Visual Basic.NET. Does anyone

know
of any good reference articles or books that address

this
subject specifically? I found one article on MSDN
called "Understanding the Excel Object Model from

a .NET
Developer's Perspective" which is good but I need more
details such as how to open and existing spreadsheet,
copy data from one range of cells on one worksheet to a
range of cells on another worksheet, etc. I am using
WindowsXP Home and Visual Studio.NET 2003.
Any help will be truely appreciated!
Regards,
Lee



.