Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
Not applicable

Makro: Get Excel-File via Dialog window

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 .

Makro_Fenster.png

Best regards
Daniel

1 Reply
MVP & Luminary
MVP & Luminary

Re: Makro: Get Excel-File via Dialog window

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