Getting a File Path

[Baladin]

Hi,

I've got a form (in Vb Express 2008) which has a TextBox and a Button saying Browse

I've managed to get the form to open the Open Dialogue when I press the Browse button, and I can use that to select the .mdb file I want, but how can I get the file path (ie. E:/Comp/Database/records.mdb) into the text box?

cheers if you can help

[leeogrady]

Basically the following, however this does not account for erronus data etc..

    Private Sub Browse_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Browse.Click
        If OpenFileDialog1.ShowDialog() = Windows.Forms.DialogResult.OK Then
            FilePath.Text = OpenFileDialog1.FileName.ToString()
        End If
    End Sub

Above code is assuming;

• the button to 'browse' is called Browse

• the file dialog is called OpenFileDialog1

• the FilePath text box is where the path is to be placed

Hope this helps
Lee

[Baladin]

that simple? suppose its all about knowing the right commands, cheers i'll give that a go

[FRANCOFABIAN]

Hello, will this code work for visual basic in excel?

Saludos

[Baladin]

great, that worked, cheers, now the tedious bit, copying and moving data, thanks again

[daniel aristidou]

great, that worked, cheers, now the tedious bit, copying and moving data, thanks again

Hi baladin.....the best way to deal with moving and copying data is by using snippets. Right click where you want to place the code and select add snippet, then locate your way around the menu provided until you find the code you need