How to insert picture from visual basic to excel application


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 2 of 2

Thread: How to insert picture from visual basic to excel application

  1. #1
    joanne Guest

    How to insert picture from visual basic to excel application


    i want to insert a logo to the excel application from visual basic. can anyone
    help me??? my sample application are :-

    In visual basic runtime, when i click the button, it will open the excel
    application and print out the record extract from Universe database in 2
    columns by 5 rows. the sample application in excel can be view like below:-


    (1,1) logo (1,2) logo
    (5,1) record1 (5,2) record4
    (7,1) record2 (7,2) record5
    (9,1) record3 (9,2) record6

    (1,1) is the column A, row 1. I can extract the record and print it in the
    excel but how to insert the logo into Excel application? thank you.




  2. #2
    Ian Guest

    Re: How to insert picture from visual basic to excel application


    "joanne" <bklin@tokiomarine.com.my> wrote:
    >
    >i want to insert a logo to the excel application from visual basic. can

    anyone
    >help me??? my sample application are :-
    >
    >In visual basic runtime, when i click the button, it will open the excel
    >application and print out the record extract from Universe database in 2
    >columns by 5 rows. the sample application in excel can be view like below:-
    >
    >
    >(1,1) logo (1,2) logo
    >(5,1) record1 (5,2) record4
    >(7,1) record2 (7,2) record5
    >(9,1) record3 (9,2) record6
    >
    >(1,1) is the column A, row 1. I can extract the record and print it in the
    >excel but how to insert the logo into Excel application? thank you.
    >
    >
    >

    Try recording a macro of you incerting a picture into your excel spread sheet.
    Then look at the VBA code that excel made to do that. (Alt + F8, edit the
    macro.)

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