GetOpenFilename Not Working

[Jmk326]

I have very simple code. I just want to open a file. The open file dialog opens, I select my file, but it doesn't actually open. Any ideas?

Sub OpenFileCopySheet()
Dim filename

filename = Application.GetOpenFilename("Excel Files (*.xlsx),*.xlsx")

End Sub

[HaHoBe]

Hi, Jmk326,

please wrap your procedure with code-tags when presenting it here.

GetOpenFilename will only deliver a string with the path and name of the file, no opening is integrated in this command. The opening could be done like

Please Login or Register  to view this content.

You could consider using an integrated dialog which would open the file instantly.

Ciao,
Holger