Thread: Using VB (Excel) Commands

  1. #1
    Registered User
    Join Date
    Sep 2004
    Posts
    35

    Question Using VB (Excel) Commands

    Hi,

    I want to write a C++ program that interacts with Excel.
    I have used the VB edit from within Excel in past, and want to be able to access or use workbook functions such as 'Workbooks.Open' but in a C++ program.

    Can I used these functions? or are the equivelent C++ functions to achieve the same thing?

    I am using MS Visual Studio 6.00


    Thanks

  2. #2
    Reverse Engineer maxorator's Avatar
    Join Date
    Aug 2005
    Location
    Estonia
    Posts
    2,318
    You could make your own object... still it would be a mess...
    "The Internet treats censorship as damage and routes around it." - John Gilmore

  3. #3
    and the hat of int overfl Salem's Avatar
    Join Date
    Aug 2001
    Location
    The edge of the known universe
    Posts
    39,656
    1. This is windows specific (moved)
    2. This involves using COM
    3. I think Ken Fitlike has posted some examples of how to do this in the past - try searching the board.
    If you dance barefoot on the broken glass of undefined behaviour, you've got to expect the occasional cut.
    If at first you don't succeed, try writing your phone number on the exam paper.

  4. #4
    Registered User
    Join Date
    Mar 2005
    Location
    Mountaintop, Pa
    Posts
    1,058
    Check out DispHelper

Popular pages Recent additions subscribe to a feed

Similar Threads

  1. Passing an Array of Strings from VB to a C DLL
    By mr_nice! in forum Windows Programming
    Replies: 9
    Last Post: 03-08-2005, 06:16 AM
  2. C++ Builder and Excel files
    By mfdemi in forum Windows Programming
    Replies: 3
    Last Post: 09-24-2004, 01:51 AM
  3. Passing parameters from VB to C++ through ActiveX DLL
    By torbjorn in forum Windows Programming
    Replies: 0
    Last Post: 12-10-2002, 03:13 AM
  4. Calling C++ DLL from Excel VB...!
    By Tony in forum Windows Programming
    Replies: 0
    Last Post: 06-26-2002, 08:07 AM
  5. VB Calling Convention?!
    By minime6696 in forum Windows Programming
    Replies: 6
    Last Post: 03-27-2002, 04:39 PM