Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range named Add_Info_** issue
Hi all,
We are using Excel for reporting in our organization. Basically there is a Java web application which instantiates Excel 2007 with an XLAM. This XLAM opens a Report Template(an .xls, .xlsm/.xlsx file). The Template has a sheet where there would be multiple ranges and the Reportsheet which shows the final report based on the data from the Datasheet. The Reportsheet contains formulae to show the final output. It could contain Charts/Graphs also. The data is fetched from SQL server and is pasted on the Ranges. And finally when all the data is pasted and User macro (a Macro from the template) is run the Template is saved as a Final Report somewhere on the Report Server. The final report could be a Excel 97-2003 workbook, Excel 2007 workbook or a PDF. The Excel runs in the background in all this process. There could be multiple instances of Excel running on the same box. The instances run under separate WindowStations. The reports are generated on the Excel instance in succession without closing it. The excel instance is only closed in case there are any error and excel stops responding. In one of the templates used by the end user had a user macro which is basically into deleting, formatting, autofitting the rows in the ReportSheet. It would select rows by the range names, defined already, and format them. The Template happens to have a set of ranges having names like Add_Info_1, Add_Info_2, Add_Info_3,......Add_Info_10. When the reports are generated as PDF (with Microsoft Office PDF addin) the first report processed on an Excel instance gets generated without any error. But when it comes to processing next reports, the user macro errors out. The reason for the user macro to error is that the ranges mentioned above are not available. The same ranges are avaialble for the first report. It was observed that if the reports are genereated in Non-PDF format then the same user macro is able to load the mentioned ranges without any error and completes succesffuly for each report. It was also observed, after doing some tests, that if the range names are like "Add_Info_And" or "Add_Info_Andan" i.e. if the range names has more than two characters attached to "Add_Info_" then user macro can load them without any problem. The problem is only with ranges which has two or less characters attached to "Add_Info_" Is there any connection with the PDF Add-in and the ranges named "Add_Info_**"? If anybody have any idea please let me know as it is a blocking issue in our process. Any help appreciated. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - Named list issue | Excel Discussion (Misc queries) | |||
Strange named range issue with multiple workbooks | Excel Discussion (Misc queries) | |||
inserting a named range into new cells based on a named cell | Excel Discussion (Misc queries) | |||
Named Range Issue | Excel Programming | |||
If any cell in named range = 8 then shade named range | Excel Programming |