I found a way to automatically generate pdf files from excel using VBA.
It uses ps intermediary format to by-pass adobe prompt.
I am now looking to consolidate several ps files in a single ps. This idea is to end with 1! pdf and not multiple.
Any idea?
Many thanks
PS: For the solution I found for pdf generation, refer to my threads.
It uses ps intermediary format to by-pass adobe prompt.
I am now looking to consolidate several ps files in a single ps. This idea is to end with 1! pdf and not multiple.
Any idea?
Many thanks
PS: For the solution I found for pdf generation, refer to my threads.