Start a new topic
Add Reply
I'm new to using VB 6, and I was wandering if there is an easy way to convert an excel file that I have, so it will run in VB as a stand alone application, rather than use excel to run it.
Converting Excel to run under VB
Page 1 of 1
Converting Excel to run under VB
Rate Topic:
MultiQuote
#2
JJ124
- New D.I.C Head
-
- Group: Members
- Posts: 27
- Joined: 27-April 09
Dream Kudos: 0
Posted 04 June 2009 - 08:50 AM
Iam not sure what you want to do,but if it is what i think, the best thing is to use MSACCESS to transfer your excel data and create a tabel with the transfer data and then create an aplication to read, write ,update, ect. your data.
Was This Post Helpful?
0
#3
sloanthrasher
- New D.I.C Head
-
- Group: Members
- Posts: 18
- Joined: 31-May 09
Dream Kudos: 0
Posted 04 June 2009 - 04:16 PM
f_thom237, on 4 Jun, 2009 - 07:29 AM, said:
I'm new to using VB 6, and I was wondering if there is an easy way to convert an excel file that I have, so it will run in VB as a stand alone application, rather than use excel to run it.
The quick answer to your question is "No". AFAIK, there isn't a readily available method to convert and Excel spreadsheet into a VB (or C++, etc.) application.
Even if you wrote an application to manipulate the data in Excel, the end user would still have to have Excel installed.
Most Excel spreadsheets are pretty simple, even when extremely large, and writing the application from scratch is not that big an undertaking. By simple, I mean that the spreadsheet mostly contains simple equations like "sum()" or adding/multiplying/etc. a few cells. If yours is more complicated than that, it should be quite a chore to write an app that does the same thing.
Was This Post Helpful?
1
#4
Jupiter 2
- New D.I.C Head
-
- Group: Members
- Posts: 12
- Joined: 05-June 09
Dream Kudos: 0
Posted 05 June 2009 - 07:28 AM
As previously answered , no. If you have a Dvelopers Excel kit, you can create a Setup Executable that will include all the object dll, ocx etc that apply to your ExcelWorkbook but this will only help if the other user also has Excel. you can't win Possibly recreate what you need in aVB6 Standalone and use the Flexigrid.
Was This Post Helpful?
1
#5
f_thom237
- New D.I.C Head
-
- Group: New Members
- Posts: 3
- Joined: 04-June 09
Dream Kudos: 0
Posted 06 June 2009 - 04:42 AM
That what I wanted to know, I was thinking that, but I thought if anybody would know I could find it here. I quess I'll roll up my sleeves and start rewriting the whole thing in code.
Thanks for all the help. You'll be seeing a lot of me as I run into problems I'm sure, and I promise I will do my homework, first.
Have a great day
Thanks for all the help. You'll be seeing a lot of me as I run into problems I'm sure, and I promise I will do my homework, first.
Have a great day
Was This Post Helpful?
0
Page 1 of 1
| 
