Export charts into excel file without installed MS-Excel on machine
Dear All
I have a macro that exports charts from QV-Application into Excel.
In QV Application there are two tabs & each tab contains multiple charts.
Here the requirement is to export these charts into a Excel & all charts from one tab should be in one Sheet & thus there will be two Sheets in a excel file.
Since MS-Excel is not installed on machine, Macro is not able run & generate this Excel file.
Is there any way to generate Excel file with two sheets & each sheet contains multiple charts without installed MS-Excel?
As a small note; its much easier to version handle and compare csv files then excel files - with could be a very time saving part if you for some reason need to do a followup on some of the data in the files.
Bindu, the reference you have provided was already checked, it requires CreateObject("Excel.Application") and thus MS-Excel installed, so is out-of my requirements.
Marcus, yes you are right that it needs to append each file (separation of objects if required - there we can use separate excels depending on requirements).
