1 Reply Latest reply: May 15, 2014 10:01 AM by Data Kruncher RSS

    Exporting to Excel Formating

    krussell _

      I just upgraded to Monarch Pro V. 9 and when I export to excel is changes my "[B],[/B]" icon on the tool bar.  I use this to format the numbers and it is now changed to a different font and style.  If I call up an excel file that was not exported from Monarch the "," style is how I want it, it is only changed on files exported from Monarch.  Does anyone know how to fix this? :confused:

        • Exporting to Excel Formating
          Data Kruncher

          Hello and welcome to the forum.

           

          It seems that you've discovered one more bug in the Monarch v9 xls export driver. It incorrectly sets the number mask in the Comma style to General.

           

          You have a couple of options:

           

          1) Don't the use Monarch v9 Excel export option. Under Options, Export and Clipboard, change from Excel 97+ (Monarch V9) to Excel 97+ (Monarch V8). It doesn't suffer from this glitch, but you won't be able to use the nice features that do work properly, like auto-outlining and auto filtering. Or,

           

          2) Write yourself a little macro to change the number format of the Comma style. Store the macro in your PERSONAL.XLS file, and assign it to a new toolbar icon. Then you can export with the V9 Excel driver, and with one click your comma format will be what you want.

           

          Here's the code I created with the macro recorder to re-define the Comma style that Monarch created for the exported workbook.

           

          Sub SetComma()

              With ActiveWorkbook.Styles("Comma")

                  .IncludeNumber = True

                  .IncludeFont = True

                  .IncludeAlignment = True

                  .IncludeBorder = True

                  .IncludePatterns = True

                  .IncludeProtection = True

              End With

              ActiveWorkbook.Styles("Comma").NumberFormat = "#,##0.00_);(#,##0.00)"

          End Sub

          /code

           

          Both options have their advantages and disadvantages, but there most definitely is an available solution.

           

          Kruncher