Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Load data from excel using Macro

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

12 Replies
farolito20
Contributor III
Contributor III

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

Not applicable
Author

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
Not applicable
Author

Check whether you did the belwo step

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

Thanks,

Leni Balakrishnan