I have a report in an excel sheet and i need to use it to display the sheet in qvw.The reason i do it is because the report is too complex to build in Qlikview and the only last option i choose is using macro. I'm relatively new to macro and it's function. Just want to make sure if macro can do that.
Another question, is it possible for me to paste a table from qvw to the exact position of the excel sheet in different excel sheet? I manage to paste the table to the excel sheet using macro below. Is there anyway to enhance it and do the task i describe above?