Visual Basic Forum for Visual Basic Programmers VB - Interactive Visual Basic Forum .NET Programming & Help

Erdem · Newbie Joined: 17 Sep 2005 Posts: 3

Hi all,
As you can understand from my nick, I am new to code writing. Here is the issue that I am seeking help for:
I have to create a little windows application which enables to reach student information, such as grades etc.. All those kind of information is ready in excel form.
I have placed 2 combo boxes. 1 for student name and the other for Lessons they take and there is a GO button to execute. Is it possible to obtain data from an excel sheet? Thanks in advance.
Regards

Digitalmetal · Newbie Joined: 15 Oct 2005 Posts: 1

Yes you can import files to you VB program.

I don't know too much about Excel, but if you add 'Microsoft Office Web Components' to your program there is a Spreedsheet object. You can use one of the following commands to import html, CSV, or XML files:

Private Sub Command1_Click()
Spreadsheet1.HTMLURL = "C:\filename.htm"
Spreadsheet1.CSVURL = "C:\filename.htm"
Spreadsheet1.XMLURL = "C:\filename.htm"
End Sub

I'm not sure how to save the files once they are imported other then to use the

Private Sub Command2_Click()
Spreadsheet1.Export
End Sub

to export them back to Excel, although that might completely go around the whole righting your own program. But if you need to just import files I hope that this helps.