Makro: Get Excel-File via Dialog window

[#1]

Hi Community,

I got a problem, i want to choose an excel file via Dialog window.
Unfortunately QlikView shows this window in the background.
So when I run the makro in a maximize QlikView-Application, I won't be able to pic a file.

My code

	set cd = CreateObject("Excel.Application")
	varData=cd.GetOpenFilename("Excel-Files (*.xls; *.xlsx; *.xlsm), (*.xls; *.xlsx; *.xlsm,,"Select file",True)

Many thanks in advance .

Best regards
Daniel

[marcus_sommer]

You could try it with:

set cd = CreateObject("Excel.Application")

cd.visible = true

varData=cd.GetOpenFilename("Excel-Files (*.xls; *.xlsx; *.xlsm), (*.xls; *.xlsx; *.xlsm,,"Select file",True)

- Marcus