HI GUYS, I AM FACING A LITTLE PROBLEM HERE. I HAVE AN APPLICATION THAT EXTRACTS DATA FROM THE DATAWAREHOUSE AND EMIAL THE DATA CONTENTS TO THE END USERS BY EXPORTING THE DATA INTO EXCEL SHEETS.The problem starts here, there are some null values in the data and they are replaced by a 0 (zero) at the report level and when the other application tries to get the data from the reports, the seo stays there but the format changes to text and the little green devil appears. No I have tried the following things: - writing a macro and disabling the error checking (not good approach as the end user still cant use that column in addition etc) ( Also I dotn want the users to see the macro dialogue popup and they might think I am trying to hack into their system) - I have tried disabling the error option but that doesnt work. - I have tried to set the format of the template file and set the format of all the cells as NUMBER but doesnt work.
Please help mein this regard. The problem should be fixed in a single template file and the same file is being used by 20 reports that are to be mailed to the business users on daily basis. I know this is a small issue, but still, CLIENT IS A CLIENT :P Please help me. Regards, shez. --~--~---------~--~----~------------~-------~--~----~ Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To post to this group, send email to excel-macros@googlegroups.com For more options, visit this group at http://groups.google.com/group/excel-macros?hl=en Visit & Join Our Orkut Community at http://www.orkut.com/Community.aspx?cmm=22913620 Visit the blog to download Excel tutorials at http://www.excel-macros.blogspot.com To Learn VBA Macros Please visit http://www.vbamacros.blogspot.com To see the Daily Excel Tips, Go to: http://exceldailytip.blogspot.com -~----------~----~----~----~------~----~------~--~---
