Macro for: Export straight table into Excel file and create a drop down menu in one field

[DataAnalytics]

Hello guys,

I am trying to solve this issue - I have a straight table and I need to export it into Excel file and create a drop down menu in one field/column.

This is the table. It contains 'name' and 'type'. 'Type' field can be either empty, or it can already have some value in it.

name	type
John
Lucy
Stephen	B
Mary
Joe	A

 The table above should be exported and the output Excel file should have a drop down menu in field 'type' as below:

type (drop down menu):

A

B

C

Please let me know your thoughts! Thank you in advance!!!

[Brett_Bleess]

You likely need to hit Microsoft forums, as you are going to need Excel APIs to do this, we have no API that is going to modify the Excel properties...

Here is a link to our QlikView APIs:

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

Regards,
Brett