CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 5 of 5

Thread: Creating Excel doc. from visual program

  1. #1
    Join Date
    Jan 2009
    Posts
    12

    Creating Excel doc. from visual program

    If I want to create a visual interactive program that will build a Microsoft Excel spreadsheet from the visual inputs, what are suggestions on how to do this. I'm still a little new to programming outside of vhdl, but I want to make it easy for my wife to sit down and take her mental recipes and create a step by step process lined out in excel; so we can gather all her recipes electronically.

    Thank you.

  2. #2
    DataMiser is offline Super Moderator Power Poster
    Join Date
    Jul 2008
    Location
    WV
    Posts
    5,349

    Re: Creating Excel doc. from visual program

    The easiest way would be to simply create a csv file then open it with excel after you are done

  3. #3
    Join Date
    Jul 2006
    Location
    Germany
    Posts
    3,725

    Re: Creating Excel doc. from visual program

    Excel features VBA which is Visual Basic for Applications.
    It is built into Excel and can be used via the Macros extra. A Macro in the end is nothing more than a small VBA sub. You can write it within Excel itself and start it as a macro. All elements of Excel are then available to programming. Workshets, cells, rows, any object of Excel can be addressed by simple VBA statements.

    Nevertheless, if Excel is on a computer, its objects are available to VB6, too, so as you can write an exe program which works outside Excel and can create/save Excel worksheets.

  4. #4
    DataMiser is offline Super Moderator Power Poster
    Join Date
    Jul 2008
    Location
    WV
    Posts
    5,349

    Re: Creating Excel doc. from visual program

    Yes you can of course. It is much easier to simply create a csv file however.

  5. #5
    DataMiser is offline Super Moderator Power Poster
    Join Date
    Jul 2008
    Location
    WV
    Posts
    5,349

    Re: Creating Excel doc. from visual program

    Personally I would use Access instead of Excel much better environment for this sort of thing than Excel

Posting Permissions

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


Windows Mobile Development Center


Click Here to Expand Forum to Full Width




On-Demand Webinars (sponsored)