 |  |  |  |  |  |  |  |
Visual Basic Tables
Please support our Visual Basic 4 / 5 / 6 advertiser: Programming Forums - DaniWeb Sister Site
 |
Ok, Ive got a program that Im working on, where it is supposed to calculate some formulas that I have based on some user inputted data and display the data in the form of a table on the same screen, and then optionally show a graph of the data plotted out.
Ive already been working on the program to have a few other features, and this is the only thing Ive got left. I would prefer to have the feature to be able to save the table as an excel sheet or a table in Wordpad.
Ive also tried a few tutorials, but I only found one that comes even close to what Im trying to do. http://www.startvbdotnet.com/ado/datatable.aspx
Thanks for any help.
Ive already been working on the program to have a few other features, and this is the only thing Ive got left. I would prefer to have the feature to be able to save the table as an excel sheet or a table in Wordpad.
Ive also tried a few tutorials, but I only found one that comes even close to what Im trying to do. http://www.startvbdotnet.com/ado/datatable.aspx
Thanks for any help.
•
•
Join Date: Nov 2007
Posts: 219
Reputation: 
Solved Threads: 24
Posting Whiz in Training
•
•
•
•
Originally Posted by Tamir09 
I would prefer to have the feature to be able to save the table as an excel sheet or a table in Wordpad.
Just convert your data to an excel format. To do this you need to have installed the Indexed Sequential Access Methods (ISAM) during the setup of Visual Basic. If you could give a small sample of the data that you want to save that would help. And if you could be clear as to your final goal?
Do you just want the data to be saved as An Excel Compatible file so that you reload it later with Excel?
•
•
•
•
Originally Posted by hkdani
Tamir:
Just convert your data to an excel format. To do this you need to have installed the Indexed Sequential Access Methods (ISAM) during the setup of Visual Basic. If you could give a small sample of the data that you want to save that would help. And if you could be clear as to your final goal?
Do you just want the data to be saved as An Excel Compatible file so that you reload it later with Excel?
Well it would be nice to save it as an excel sheet.
I just need some kind of hint or maybe a webpage of a tutorial to get me moving in the right direction. As far as creating, editing and saving to an excel sheet through a VB program.
•
•
Join Date: Dec 2004
Posts: 2,413
Reputation:
Solved Threads: 211
While not excel specific, this should get you on your way:
http://www.daniweb.com/tutorials/tutorial51307.html
http://www.daniweb.com/tutorials/tutorial51307.html
•
•
•
•
Originally Posted by Comatose
While not excel specific, this should get you on your way:
http://www.daniweb.com/tutorials/tutorial51307.html
The first part of the program calculates a set of numbers, so when it does that, its supposed to put those values in a table. When I go to calculate the next set, it should recall those values so that the program can calculate the new values. But it shouldnt delete or over write the values from the first calculation. I have an excel sheet with all the various calculations, and Im trying to convert this excel program into a Windows Application program.
•
•
Join Date: Nov 2007
Posts: 219
Reputation:
Solved Threads: 24
Posting Whiz in Training
•
•
•
•
I read through that tutorial, and its not quite what I need.
This program gives example code on importing and exporting data to and from excel files along with a host of other database tasks.
•
•
Join Date: Nov 2007
Posts: 219
Reputation:
Solved Threads: 24
Posting Whiz in Training
•
•
•
•
I didnt know that Visual Studio came with this kind of stuff.
There's too many functions, controls, and features to memorize them all.
Ok I got it sort of to work, but the XML file wont get read, and it gives me errors saying that the data is unable to be written to the excel sheet. Im using the excel sample from the visual studio samples.
On another note, does anyone know how to open a form from another project into the current project?
On another note, does anyone know how to open a form from another project into the current project?
|
Similar Threads
- Visual Basic.Net (Community Introductions)
- Crystal Report 11 and Visual Basic 6.0 sql query.... (Visual Basic 4 / 5 / 6)
- Get visual basic to bring up another form when a button is clicked (Visual Basic 4 / 5 / 6)
- Error when making an event procedure in Visual Basic (C)
Other Threads in the Visual Basic 4 / 5 / 6 Forum
- Previous Thread: Rename Start Button
- Next Thread: Change MS access table design
Views: 1746 | Replies: 12
| Thread Tools | Search this Thread |
Latest Visual Basic 4 / 5 / 6 Posts
- Today's Posts
- Unanswered Threads
Related Forum Features
Tag cloud for Visual Basic 4 / 5 / 6
* 6 429 2007 access activex add age append application basic beginner birth bmp c++ calculator cd cells.find click client code college column component connection copy creat ctrl+f data database datareport date delete dissertations dissertationtopic edit error excel excelmacro file filename form hardware header iamthwee image inboxinvb internetfiledownload keypress label listbox listview liveperson login looping machine microsoft movingranges number objectinsert open oracle password prime program prompt range-objects readfile reading record refresh remotesqlserverdatabase report retrieve save search sendbyte sites sort sql sql2008 sqlserver struct subroutine table tags textbox time timer urldownloadtofile vb vb6 vb6.0 vba visual visualbasic visualbasic6 web window windows
