You can't that simple. VBA do not support that solution.
To see good automatization in code you should reference to Adobe full version (not reader)
or you can try to use MSWord for import and export (1:10 success)
or look for power automate in business 365 license
or use OCR programs to do that
or web applications
or cellphones applications based on the same sue.
If you use outside services, you giving them your files for good.