more quick actions
minimize quick actions
Topic starter
Hello,
does anyone have a solution to print directly a new generated report (from Data Export) in a pdf file with a ".bat", powershell, or something else?
It's for a CFR 21 part 11 project.
Thank you
Manu
Posted : 15/12/2020 5:11 pm
You can use PDFCreator Free to do that, it is available on pdfforge. Edouard has made some video few years ago:
https://staging.pcvue.com//community/general/printing-to-pdf-file-with-pdfcreator/#post-930
This post was modified 2 years ago by LM
Posted : 15/12/2020 7:12 pm
Hi,
I think the subject is more: How to print automatically an exported file that has been generated?
Nico
Posted : 15/12/2020 7:15 pm
Topic starter
Exactly Nico,
I am checking Pdf Architect, but I can't find some parameters that check new file in a folder to convert it in a pdf file. 🙁
Some new ideas?
Manu
Posted : 15/12/2020 7:56 pm
OK, I did it years ago and the best way I found was to trigger an event when the Export is completed (using the status variable).
The VBA script opens the Excel file and print it.
Nico
Posted : 16/12/2020 3:19 pm
Hi Nico
ive same requirement right now to print data export in pdf. any more notes on this pls?
chinmayi
Posted : 18/01/2021 12:33 pm
Hi Chinmayi,
My answer is not enough?
Actually I talked with Manuel about this requirement. My answer is OK but you must have Excel installed on the computer.
Actually, there are several solutions to this problem but all need Excel installed.
Nico
Posted : 18/01/2021 3:26 pm
Hi Nico
ive tried this but haven't succeed. any workaround available for this? or may be my way is not correct?
please help.
Chinmayi.
Posted : 18/01/2021 7:50 pm
Send me your project, I will check and let you know where is the issue.
nico
Posted : 18/01/2021 10:11 pm
Hi Chinmayi,
How did it end?
Is it ok to print the exported file?
Edouard
Posted : 24/01/2021 6:22 pm
yes Edouard !
working fine.
thank you
Chinmayi
Posted : 25/01/2021 10:49 am
Topic starter
HI everybody,
is it possible to share the entire answer like a procedure to succeed this please?
Thanks
Posted : 25/01/2021 3:44 pm
Hello
I have managed to do it like this.
so here is the VB code which I am running. It will give output straight as to PDF. its reading the value from triggering status variable and preparing the PDF. I have one excel file with 3 sheets in it. by using this code its generating 3 different pdfs for each sheet with specific format of file name and generation time . (please update excel template as per need and copy that to data export template of project folder).
for adding references after browsing we can look for C:Program FilesMicrosoft OfficerootOffice16EXCEL.EXE.
I am adding some screenshots and also VBA code for reference.
Thanks you!
Chinmayi
Posted : 25/01/2021 4:02 pm
In 1 word,
That's the solution I gave you orally Manu. But, in your case it didn't work because Excel is needed on the station where the VBA is running.
Nico
Posted : 25/01/2021 5:36 pm