Generate and merge several files by the COMS interface

Hi all,

I try (in vain !) to generate a pdf file from several src files (word, visio, excel and pdf).

I found the tool convert2pdf but not completely OK for my needs, for instance if an excel file contains vba macros, I'm invited to click if I accept to run them and when it is closed, a dialog box asks me if I want to save the file !!! In addition, when I want to merge all the files, acrobat reader is opened and I need to close it, so that pdfCreator can print the current file. Otherwise, nothing happens.

I also tried with a vba macro but it takes much more time than the 1st solution.

Does anybody already do this ? Please can you help me ?

 

Thank you in advance.

 

 Call the windows api to close the window named "Acrobat Reader".

Regards

Yes good idea ! but how can I do that ?

thanks

Example in VFP:

 

Declare Integer PostMessage In Win32Api ;

Integer hWnd, ;
Integer Msg, ;
Integer wParam, ;
Integer lParam
 
WM_CLOSE = 16
 
 
.........
 
PostMessage(FindWindow(Null,"Adobe Reader"),WM_CLOSE,0,0)

 

I'm sorry but I'm a beginner ! and I dont know VFP.

The script I use is in wsh environment.
Thank you for your help.

windo