Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm using a macro to Export a pivot table to Excel. This works great except for the number formatting is not working. In Qlikview I have my numbers formatted to #,##0 but when it exports to Excel the comma is gone. Money and percents work fine it is only the number cells that are causing a problem. Any ideas?
Export to excel only exports the data, not the formatting. You can create a macro that first exports the data and then in excel adds the formatting. See this discussion for an example document.
Thank you! I was able to find out how to change a column in the macro but I need to change just a row. Do you know the syntax for that?
Not in detail. I usually try to google something like that. Perhaps these two links give you enough information to figure it out:
VBA For Microsoft Excel: The Rows of a Spreadsheet
http://www.ravisagar.in/blog/how-change-background-color-entire-row-excel-using-vba-code-conditional
Thank you!