I would like to create a dropdown list where the column names can be renamed. I want to give the user the option of picking the column name to rename from a dropdown box instead manually renaming it or indexing. Any ideas on what is the best route?
I found work around with this macro.
Hi mdata,
You would start by populating the dropdown with the fieldlist. The important thing there is to connect the q from the Macro Input, not the arrow connector.
Then you just have to set up a text input so that you have the old field name and new field name so that you can run it into the dynamic rename.
I've attached the Macro if that method doesn't make sense.
Kane
I have 2 file names here Named Book3 where macro input in coming from. The columns names in Book3 are incorrect but I want the user to pick and choose which columns names from file Column Names. I would like multiple dropdown boxes with all the column names from the Book3 and all the Columns Names from Columns Names file.
