Opening Files Using Visual Basic

[Ste_Moore01]

Hi guys,

I've started to dabble a little with Visual Basic 6 and I'm struggling with something.

I've managed to make a Common Dialog Box that shows a window to open other files.

When you click on a file and click "Open" nothing happens. Obviously I need to add some code.

Can anyone tell me what code I need to add because I can't figure out how to open files using VB.

I want it to be able to open any file using the file's default program to open.

Can anybody help me?

 

[Joe4]

Here is some code I frequently use:

    myfile = Application.GetOpenFilename("All Files,*.*")
    If myfile = False Then
        Exit Sub
    End If
    Workbooks.Open Filename:=myfile

 

[Ste_Moore01]

Oops!

I've just noticed I've posted this in the wrong forum.

I'm actually using Visual Basic 6 and not the VB in Excel.

I'm sorry for any confusion. Could somebody move this for me or should I post a fresh topic on the correct board?

 

[Joe4]

I'll move it.

 

[Ste_Moore01]

Thank you very much.

 

[Ste_Moore01]

I'm guessing that no-one uses visual basic 6 then...