dcsimg


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: Loading data into Excel using VB6

  1. #1
    Join Date
    Nov 2004
    Posts
    293

    Loading data into Excel using VB6

    I have a VB6 program where I am loading some data into some excel worksheets all in the same workbook. I want to load data into other then my selected worksheet without having to show(or select) that other worksheet at all. How can I do that?

  2. #2
    Join Date
    Apr 2007
    Location
    Sterling Heights, Michigan
    Posts
    8,663
    Explicitly use its name
    Code:
    Sheets("Sheet2").Range("B1").Value = "AM003295"

Similar Threads

  1. Summarize Data in Excel
    By Ron Weller in forum Database
    Replies: 2
    Last Post: 02-26-2008, 08:45 PM
  2. Replies: 1
    Last Post: 07-25-2001, 06:17 PM
  3. Import Data from Excel to Access thru VB 6
    By Sinni in forum VB Classic
    Replies: 7
    Last Post: 06-08-2001, 03:14 PM
  4. Data Junction Announces XML Junction 7.51
    By Tim Frost in forum xml.announcements
    Replies: 0
    Last Post: 04-02-2001, 10:53 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center