VBA Functionality import / export functions

Hi,

for a project, I need to open different *.gan files from Excel, Export the data and import it into an Excel-File, where I need to process some of this data further.
Is there any possibility to do so from VBA side? So far I have not found any working code.

Thanks a lot.

I need to open different *.gan files from Excel

You can just export data from GanttProject to CSV file instead.
If you really need to do it programmatically, you can start ganttproject executable with command line aguments. I didn’t try it on Windows, but on Linux the following produces CSV from .gan:

ganttproject -export csv ./MyProjectFile.gan

I do Need to open it with Excel, as I Need to gather data out of various *.gan’s and process this data. The whole Thing should run automated. Once I get it exported as csv, it is not a Problem anymore.

So, try executing this export command from VBA script.