VB newb Open File Dialog
VB newb Open File Dialog
VB newb Open File Dialog
VB newb Open File Dialog
VB newb Open File Dialog
VB newb Open File Dialog VB newb Open File Dialog VB newb Open File Dialog VB newb Open File Dialog VB newb Open File Dialog VB newb Open File Dialog VB newb Open File Dialog VB newb Open File Dialog
VB newb Open File Dialog VB newb Open File Dialog
VB newb Open File Dialog
Go Back  Xtreme Visual Basic Talk > > > VB newb Open File Dialog


Reply
 
Thread Tools Display Modes
  #1  
Old 04-29-2011, 04:57 AM
ToolJob ToolJob is offline
Newcomer
 
Join Date: Apr 2011
Posts: 1
Default VB newb Open File Dialog


Hi

I am a VB newb and trying to figure out how to use a file open dialog in my small program instead of using a statically set path. I want to use the open file dialog button to find a file to look up Excel row/column values. I search for an example on how but I can't see to find one. Thanks in advance to anyone who can shed light on my problem for me!

Thx ToolJob



Code:
Imports Microsoft.Office.Interop
Imports System.IO

Public Class Form1

    Dim APP As New Excel.Application

    Dim worksheet As Excel.Worksheet

    Dim workbook As Excel.Workbook


 Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click



        ' lblTest.Text = results

        workbook = APP.Workbooks.Open("c:\temp\testDB.xls")

        worksheet = workbook.Sheets.Item(1)

        'Read the value from Cell A1, B1

        TextBox1.Text = worksheet.Cells(8, 1).Value

        TextBox2.Text = worksheet.Cells(8, 2).Value

        APP.ActiveWorkbook.Close(False, "c:\temp\testDB.xls")

        APP.Quit()


    End Sub
End Class
Reply With Quote
  #2  
Old 04-29-2011, 09:45 AM
AtmaWeapon's Avatar
AtmaWeaponVB newb Open File Dialog AtmaWeapon is offline
Fabulous Florist

Forum Leader
* Guru *
 
Join Date: Feb 2004
Location: Austin, TX
Posts: 9,500
Default

Have you looked at the documentation? Not only does it have an example, it is a roadmap to everything you can do with the class.

Don't get stuck on trying to follow the example literally; it does something different than what you're doing. Here's the process I'd suggest:
  • Display the dialog with ShowDialog().
  • If the dialog returns DialogResult.OK, the user selected something.
  • Use the FileName property to get the path to the selected file.
__________________
.NET Resources
My FAQ threads | Tutor's Corner | Code Library
I would bet money 2/3 of .NET questions are already answered in one of these three places.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
VB newb Open File Dialog
VB newb Open File Dialog
VB newb Open File Dialog VB newb Open File Dialog
VB newb Open File Dialog
VB newb Open File Dialog
VB newb Open File Dialog VB newb Open File Dialog VB newb Open File Dialog VB newb Open File Dialog VB newb Open File Dialog VB newb Open File Dialog VB newb Open File Dialog
VB newb Open File Dialog
VB newb Open File Dialog
 
VB newb Open File Dialog
VB newb Open File Dialog
 
-->