Formatting Data Type in Modeler Export file.

[Lukas.Knapek]

Hello again Rebecca,

Download the attached file and follow these steps:

1. Open your exported excel file and display Developer tab.

2. Switch to the Review tab and make sure to **Unprotect Sheet ** (and Workbook, if it is protected). Otherwise, the macro won't work.
   

   

3. Now switch to the Developer tab and click the Visual Basic button.
   

   

4. A new windows opens, right-click Microsoft Excel Objects and choose Import File.
   

   

5. Navigate to the file you downloaded from this post and import it. You can now close the Visual Basic window.

6. In Developer tab, click Macros and you should see the imported macro as seen on screenshot. Click Run to execute it.
   

   

7. A new column should appear - Data Types with Params, which contains the Data types and both of their parameters. Data Type and Data Type Params 1/2 should be deleted.
   

   

I hope this is what you needed.

Regards,

Lukas
DataTypeParameters.bas (1.4 KB)