Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
gopal5879
Creator
Creator

macro to write to an existing custom  template excel file

Can some one help or guide me about a macro to write to an existing custom  template excel file

with excel  cell having ability to select from a list of default values. 

Labels (2)
4 Replies
QFabian
Specialist III
Specialist III

hi, you have to use macro vba functions, i atached an old pdf with definitions and an old qvw file with the description and examples of every function

 

enjoy 

try this link too:

https://help.qlik.com/en-US/qlikview-developer/April2020/Subsystems/Automation/Content/QV_Automation...

 

QFabian
QFabian
Specialist III
Specialist III

dont forget that you can record your macros n excel, for example deleting a cell or putting a value into a cell, then you can use that code and do little modifications to make it work with qlikview

QFabian
gopal5879
Creator
Creator
Author

Thanks a lot Fabian, appreciate your help. Will go over info

Brett_Bleess
Former Employee
Former Employee

@gopal5879 In addition to what Fabian gave you, which will be our APIs, you may also need Excel APIs in which case Microsoft Visual Basic Forums are going to be the place to go for help with those, as the experts will be there in this case.  

Regards,
Brett

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.