Does anyone know if it is possible to use VBA from Excel
to control Adobe Acrobat?

I need to convert quite a few files into PDF and then
compile them into one document.

Any help out there? Or am I simply out of luck?