Results 1 to 13 of 13

Thread: My Excel work....

  1. Dec 2nd, 2004, 01:05 AM #1
    blind
    blind is offline

    Thread Starter
    Junior Member
    Join Date
    Dec 2004
    Posts
    16

    My Excel work....

    Ive made an excel document and i was wondering if i could make it into a vb program because i need to give it to people and they may not have excel. The excel document uses 3 sheets.
    Reply With Quote Reply With Quote
  2. Dec 2nd, 2004, 01:20 AM #2
    dglienna
    dglienna is offline
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901
    anything is possible. do you know VB? or VBA?
    Reply With Quote Reply With Quote
  3. Dec 2nd, 2004, 01:34 AM #3
    blind
    blind is offline

    Thread Starter
    Junior Member
    Join Date
    Dec 2004
    Posts
    16
    I got vb6, do i have to completely rewrite it in vb or can i convert it somehow.
    Reply With Quote Reply With Quote
  4. Dec 2nd, 2004, 01:40 AM #4
    dglienna
    dglienna is offline
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901
    you have to re-write it, unless you have written a lot of VBA code within Excel.
    Reply With Quote Reply With Quote
  6. Dec 2nd, 2004, 01:54 AM #5
    Bolerophone
    Bolerophone is offline
    Lively Member Bolerophone's Avatar
    Join Date
    Dec 2003
    Location
    Himalayas
    Posts
    123

    Re: My Excel work....

    Originally posted by blind
    Ive made an excel document and i was wondering if i could make it into a vb program because i need to give it to people and they may not have excel. The excel document uses 3 sheets.

    I don't think with your application can create a excel file if MS-Excel is not installed on the machine.
    Jobs: "Do u want to sell colored sugar water or change the world?"

    Get Firefox Now!!!
    Mendhak leaving town.
    Reply With Quote Reply With Quote
  7. Dec 2nd, 2004, 02:23 AM #6
    blind
    blind is offline

    Thread Starter
    Junior Member
    Join Date
    Dec 2004
    Posts
    16

    Re: Re: My Excel work....

    Originally posted by Bolerophone
    I don't think with your application can create a excel file if MS-Excel is not installed on the machine.
    I dont entirely understand what u said

    but i want to conver MY excel document into a VB program (exe) so people without excel can use it.
    Reply With Quote Reply With Quote
  8. Dec 2nd, 2004, 02:25 AM #7
    dglienna
    dglienna is offline
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901
    You can't. You can do many if not all of the same things with VB, but Excel uses their own system for doing things that are not transportable.
    Reply With Quote Reply With Quote
  9. Dec 2nd, 2004, 02:34 AM #8
    blind
    blind is offline

    Thread Starter
    Junior Member
    Join Date
    Dec 2004
    Posts
    16
    is it possible to make an exe and intergrate my excel sheet?
    Reply With Quote Reply With Quote
  11. Dec 2nd, 2004, 03:00 AM #9
    dglienna
    dglienna is offline
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901
    users would still have to have excel on their system.
    Reply With Quote Reply With Quote
  12. Dec 2nd, 2004, 03:31 AM #10
    blind
    blind is offline

    Thread Starter
    Junior Member
    Join Date
    Dec 2004
    Posts
    16
    hmmmm, oh well, how do i do that neways?
    Reply With Quote Reply With Quote
  13. Dec 2nd, 2004, 03:52 AM #11
    dglienna
    dglienna is offline
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901
    what does the spreadsheet do? You could use VBA to put forms on it, and do just about anything that you'd want to do with VB, or you could use VB to open the spreadsheet.

    What are you looking to do with the program that you can't do with just the spreadsheet?
    Reply With Quote Reply With Quote
  14. Dec 2nd, 2004, 04:16 AM #12
    blind
    blind is offline

    Thread Starter
    Junior Member
    Join Date
    Dec 2004
    Posts
    16
    some calcs here and there, gets values from sheet 2 and does calcs on sheet 1, stuff like that.
    Reply With Quote Reply With Quote
  15. Dec 2nd, 2004, 05:42 AM #13
    Bolerophone
    Bolerophone is offline
    Lively Member Bolerophone's Avatar
    Join Date
    Dec 2003
    Location
    Himalayas
    Posts
    123
    Originally posted by blind
    is it possible to make an exe and intergrate my excel sheet?
    You can use an OLE container control and refer a Excel object into it. The OLE container control enables you to add insertable objects to the forms in your Visual Basic applications.
    But it will again require excel to be present on the user's machine.
    Jobs: "Do u want to sell colored sugar water or change the world?"

    Get Firefox Now!!!
    Mendhak leaving town.
    Reply With Quote Reply With Quote
« Previous Thread | Next 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
  •  

Forum Rules


Click Here to Expand Forum to Full Width