Please explain the difference between these

[Eisasuarez]

Hi Can someone please explain what the difference is between these and when to use 1 over the other

Application.GetOpenFilename
Application.Dialogs(xlDialogOpen).Show
Application.FileDialog(msoFileDialogOpen).Show

 

[RoryA]

The first two don't exist in Access, so I'd stick with the third option.

 

[Eisasuarez]

The first two don't exist in Access, so I'd stick with the third option.

Sorry RoryA - I was meant to put it into the excel forum bit

What is the difference mate and when shall i use one over the other?

 

[RoryA]

GetOpenFilename doesn't actually open anything, it just returns a file name.
The other two will both open the selected file (assuming you don't press Cancel).

The Dialogs() property returns a Dialog object which only really has Show as a useful method/property (you can pass certain arguments (they vary by dialog) to it).

The FileDialog() property does much the same but has a lot more properties that you can set - it's easier to work with IMO, but there are only 4 FileDialog objects, as opposed to the hundreds of Dialog objects.