using application.getopenfilename keeps opening new app

[mg25683]

Hi, I have a strange issue that happens only on my machine.
Simply running the line with application.getopenfilename opens a new application (I mean new a p p l i c a t i o n/ excel process)
The arguments/other factors do not matter, I get the same effect even if i run the line in the immediate window.

Any idea?

[Aussiebear]

Without seeing your code, we are simply guessing, however are you using this in the following format



Filename = Application.GetopenFileName

[mg25683]

Without seeing your code, we are simply guessing, however are you using this in the following format


[/CODE]

What are you guessing bro?

1. Put "application.GetOpenFilename" in immediate window
2. Hit enter
3. Select any file

Bang! New application opens

[mg25683]

office reinstall didnt help:(

[snb]

Hi sis, why don't you use Excel ?


Sub M_snb()
With Application.FileDialog(3)
If .Show Then Workbooks.Open .SelectedItems(1)
End With
End Sub

[Tom Jones]

Hi sis, why don't you use Excel ?


Sub M_snb()
With Application.FileDialog(3)
If .Show Then Workbooks.Open .SelectedItems(1)
End With
End Sub

:clap::clap::clap::clap::clap::clap::clap::clap::clap:

[mg25683]

For some reason, application.filedialog has exactly the same effect - new excel process opens up

(once again: it opens up when the dialog is used, even without workbooks.open )

[georgiboy]

So if you run the below in a new excel file, does it open the file or return the name and location:

Sub GetFileName()
Dim Finfo As String
Dim Title As String
Dim FileName As Variant

Finfo = "All Files (*.*),*.*"
Title = "Select a File"

FileName = Application.GetOpenFilename(Finfo, , Title)

If FileName = False Then
MsgBox "No file was selected."
Else
MsgBox "You selected " & FileName
End If
End Sub

[Paul_Hossler]

What are you guessing bro?

1. Put "application.GetOpenFilename" in immediate window
2. Hit enter
3. Select any file

Bang! New application opens

Then don't use the Immediate Window

Use .GetOpenFilename in a macro

[Jan Karel Pieterse]

Does not happen for me. I suggest to do an on-line repair of your Office installation.