Load data from excel using Macro

[Anonymous]

Hi All,

Can any help me in loading the data from excel file to the Qlikview using Macro.

Using Macro I need to create connection to excel and load the data from excel to Qlikview.

Thanks in Advance

Thanks,

Leni

[farolito20]

How can I load data from a qvd file using macro?

[#3]

Hi

I am getting one error message :-

ActiveX component can't create object: 'Excel.Application'

Can you help me what is the problem ?

Thanks

[Anonymous]

Check whether you did the belwo step

Set Current Local Security -> Allow System Access in Macro settings

Thanks,

Leni Balakrishnan