Skip to Content
avatar image
Former Member

Excel download with listbox / Dropdown in one column for field plant

Requirement is to add dropdown and set values to one field to excel file downloading with predefined format of few columns.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Jun 02, 2017 at 12:25 PM

    Hi!

    You can record a macro using such steps: go to Data tab, select Data Validation and set Allow = List, Source = range of cells which contain allowed values. And then call this macro while creating your output.

    Hope it's helpful

    Evgeny

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for writing..

      I am not getting direction to it that how to initiate as right now i am just using GUI_Download to download file and passed structure excel.

      If i get how to write and what to then i will be able to manage.

  • Jun 02, 2017 at 12:22 PM

    Did you perform some search on OLE, and Excel macro recording /or/ look for abap2xlsx project.

    Add comment
    10|10000 characters needed characters exceeded