CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2000
    Location
    Germany
    Posts
    116

    Contact from VS C++ to Excel VBA

    I've got an app written in Visual Studio C++ that deals with excel lines of data and presents it in a Form.

    I now need to print the data. A while back I wrote this app in VBA and printing was a simple task of calling UserForm1.Print

    How can I get my C++ app to call up this UserForm1 and call that UserForm1.Print command?

    Once I get the connection between these two entities I can send the data I want printed and let VBA do the print work.

    How does my C++ talk to my Excel VBA?

    Thanks for anything
    Klatau Broada Nektau

  2. #2
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,222

    Re: Contact from VS C++ to Excel VBA

    Are you using an excel automaton in your VC++ code?
    Victor Nijegorodov

  3. #3
    Join Date
    Apr 2000
    Location
    Germany
    Posts
    116

    Re: Contact from VS C++ to Excel VBA

    I don't know what excel automation is.
    I learned C++ in the 1970s, really.
    I use a third party software "libxl" to read cells write cells and open/save workbooks/sheets.
    Klatau Broada Nektau

  4. #4
    VictorN's Avatar
    VictorN is offline Super Moderator Power Poster
    Join Date
    Jan 2003
    Location
    Hanover Germany
    Posts
    20,222

    Re: Contact from VS C++ to Excel VBA

    Quote Originally Posted by Albatross View Post
    I don't know what excel automation is.
    How to automate Excel from C++ without using MFC or #import
    How to automate Excel from MFC and Visual C++ 2005 or Visual C++ .NET to fill or obtain data in a range using arrays

    Quote Originally Posted by Albatross View Post
    I use a third party software "libxl" to read cells write cells and open/save workbooks/sheets.
    Doesn't this "libxl" have a Print function?
    Victor Nijegorodov

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured