defining and initializing objects

Posted on 2004-11-08
Last Modified: 2010-04-23
How can i define the Objects below.
I am using those Object in a function parse an excel sheet into access databae.

Dim objExcel As Excel.Application
Dim objWorkBook As Excel.Workbook
Dim objWorksheet As Excel.Worksheet
Dim worklistsheet As Excel.Worksheet
Question by:komlaaa
    LVL 10

    Accepted Solution

    Go through the following link. It gives a clear method of using the various excel objects
    LVL 3

    Assisted Solution

    There is another way to do this; query the excel sheet as you would any other data source. You need a driver (like with any other database) and you can query it using standard sql. Then just iterate through your dataset and create insert statements for your destination database.

    This covers the idea, im sure there are plenty of VB.NET examples around as well....

    LVL 25

    Assisted Solution

    Don't forget you have to reference the Excel object library before you can use those objects.

    References/add reference, choose the COM tab, and locate the microsoft Excel X.X object library

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Suggested Solutions

    This tutorial demonstrates one way to create an application that runs without any Forms but still has a GUI presence via an Icon in the System Tray. The magic lies in Inheriting from the ApplicationContext Class and passing that to Application.Ru…
    Creating an analog clock UserControl seems fairly straight forward.  It is, after all, essentially just a circle with several lines in it!  Two common approaches for rendering an analog clock typically involve either manually calculating points with…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    11 Experts available now in Live!

    Get 1:1 Help Now