Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem, I'm trying to read a excel file from module editor of qlikview but I don't know how to do it (I'm trying to use the getOpenFileName function but it doesn't work). I want to do it because i need to read all the registers of the first column of the excel file and after select all of them using the SelectValues function.
Would it be possible?
Thanks in advance
If you have Excel installed on the computer that is running the macro you could use Windows Automation to grab hold of Excel and find the values you need and then do a selection based on that.
What makes it necessary to do it in the first place?
If you have Excel installed on the computer that is running the macro you could use Windows Automation to grab hold of Excel and find the values you need and then do a selection based on that.
What makes it necessary to do it in the first place?
You're right Peter. I have be able to use Windows automation.
Thanks a lot