VB School Assignment? Project Due Tomorrow? Chat LIVE With A Programming Expert!

Welcome to Dream.In.Code
Become a VB Expert!

Join 300,327 VB Programmers for FREE! Get instant access to thousands of VB experts, tutorials, code snippets, and more! There are 1,924 people online right now. Registration is fast and FREE... Join Now!




Converting Excel to run under VB

 

Converting Excel to run under VB

f_thom237

4 Jun, 2009 - 07:29 AM
Post #1

New D.I.C Head
*

Joined: 4 Jun, 2009
Posts: 3

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.

User is offlineProfile CardPM
+Quote Post


JJ124

RE: Converting Excel To Run Under VB

4 Jun, 2009 - 08:50 AM
Post #2

New D.I.C Head
*

Joined: 27 Apr, 2009
Posts: 27

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.
User is offlineProfile CardPM
+Quote Post

sloanthrasher

RE: Converting Excel To Run Under VB

4 Jun, 2009 - 04:16 PM
Post #3

New D.I.C Head
*

Joined: 31 May, 2009
Posts: 17



Thanked: 1 times
My Contributions
QUOTE(f_thom237 @ 4 Jun, 2009 - 07:29 AM) *

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.
User is offlineProfile CardPM
+Quote Post

Jupiter 2

RE: Converting Excel To Run Under VB

5 Jun, 2009 - 07:28 AM
Post #4

New D.I.C Head
*

Joined: 5 Jun, 2009
Posts: 12



Thanked: 1 times
My Contributions
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.

User is offlineProfile CardPM
+Quote Post

f_thom237

RE: Converting Excel To Run Under VB

6 Jun, 2009 - 04:42 AM
Post #5

New D.I.C Head
*

Joined: 4 Jun, 2009
Posts: 3

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. smile.gif Have a great day
User is offlineProfile CardPM
+Quote Post

Fast ReplyReply to this topicStart new topic

Time is now: 11/7/09 03:24PM

Live VB Help!

Be Social

Dream.In.Code RSS Feed Dream.In.Code LinkedIn Group Follow Us On Twitter Fan Us On Facebook

VB Tutorials

Reference Sheets

VB Snippets

DIC Chatroom

Bye Bye Ads

Monthly Drawing

Thumb Drive

Top Contributors

Top 10 Kudos This Month