Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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