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.
Printable View
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.
anything is possible. do you know VB? or VBA?
I got vb6, do i have to completely rewrite it in vb or can i convert it somehow.
you have to re-write it, unless you have written a lot of VBA code within Excel.
Quote:
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.
I dont entirely understand what u saidQuote:
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.
but i want to conver MY excel document into a VB program (exe) so people without excel can use it.
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.
is it possible to make an exe and intergrate my excel sheet?
users would still have to have excel on their system.
hmmmm, oh well, how do i do that neways?
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?
some calcs here and there, gets values from sheet 2 and does calcs on sheet 1, stuff like that.
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.Quote:
Originally posted by blind
is it possible to make an exe and intergrate my excel sheet?
But it will again require excel to be present on the user's machine.