Makro: Get Excel-File via Dialog window

Mon, 04 Sep 2017 11:32:15 GMT

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

Re: Makro: Get Excel-File via Dialog window

marcus_sommer — Tue, 05 Sep 2017 10:42:56 GMT

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

topic Makro: Get Excel-File via Dialog window in QlikView

Makro: Get Excel-File via Dialog window

Re: Makro: Get Excel-File via Dialog window