Query reportr & VBA

[pompoko]

Hello

Do you have any documentation or a guide wich could be helpful to use in VBA ? I try to find how to modify datas in .rep files and export the results in excel by using vba

Many thanks in advance for your help

 

[Marco Kalter]

Unfortunately we do not have any information about this.

 

[pompoko]

Hello

Ok thank you for your answer.

And in the command line is it possible to specify a directory where the export will be saved or it will automatically saved in the same directory as .exe ?

 

[Marco Kalter]

For the HTML=, XML= and TSV= parameters you can specify the complete path name for the output file.

 

[pompoko]

so the end of the command should be :

--- exec=Name_of_query.rep EXCEL=c:\results\Results.xlsx quit

for exemple ?

 

[Marco Kalter]

Yes, that is indeed correct.

 

[pompoko]

Thanks, with "" it works perfectly