ExcelNewbie
Programmer
All,
Iam involved in a project which generates reports in MS Excel sheets. The application (C++ program using Oracle call Interface) uses a template Excel Workbook, say template.xls. This is used to populate data from a Oracle data source and save it to a output.xls workbook based on the format in the template.xls workbook. The program works by copying the template.xls workbook to output.xls workbook and in doing so, replace the template data in template.xls with the actual data from the database into the output.xls.
A new requirement is to add hyperlinks to the values of a column in the output.xls file. As the hyperlinks cannot be generated directly from the c++ programs, I use VBA scripts in the template.xls file. But now, the output.xls file generated by the same c++ program fails to show the populated data, instead it shows the data as found in template.xls file.
Any idea how do I get around this situation?
Thank you,
ExcelNewbie
Iam involved in a project which generates reports in MS Excel sheets. The application (C++ program using Oracle call Interface) uses a template Excel Workbook, say template.xls. This is used to populate data from a Oracle data source and save it to a output.xls workbook based on the format in the template.xls workbook. The program works by copying the template.xls workbook to output.xls workbook and in doing so, replace the template data in template.xls with the actual data from the database into the output.xls.
A new requirement is to add hyperlinks to the values of a column in the output.xls file. As the hyperlinks cannot be generated directly from the c++ programs, I use VBA scripts in the template.xls file. But now, the output.xls file generated by the same c++ program fails to show the populated data, instead it shows the data as found in template.xls file.
Any idea how do I get around this situation?
Thank you,
ExcelNewbie
