Question

Document Macro script

  • 9 December 2021
  • 1 reply
  • 315 views

Hi,

Is it possible to have document macro to execute when check-in files in pdf format add a blank page to the first page of the document Or something like, count number of rows and update that in a custom table?

Also looking for a solution to convert word file into pdf and view using macro. If anyone came across would be appreciate if you can share the macro script you tried.


Thanks

Nimesh


This topic has been closed for comments

1 reply

Userlevel 7
Badge +30

Is it possible to have document macro to execute when check-in files in pdf format add a blank page to the first page of the document Or something like, count number of rows and update that in a custom table?

 

If you can find a tool that can manipulate the PDF for you, yes! I know there is at least one open source PDF toolkit out there that can do various things with them. Search for “pdf tool command line” and you will find some (PDFtk seems familiar there...) Once you learn how the tool can be used from the command line, it’s not hard to bring that into the macro (VBScript).

Also looking for a solution to convert word file into pdf and view using macro. If anyone came across would be appreciate if you can share the macro script you tried.

 

Can you elaborate on “convert word file … and view”?

With modern Word versions you can easily create a PDF using Word’s built in features. Start with a VBA macro that does this, then bring that in to VBScript. Heck, if you google for “convert Word to PDF using VBScript” or similar, you will find it.

I will move this into the Docman discussion area now…