creating a single PDF file by combining a collection of different file types using VBA
Hi -
Does anyone know how to use VBA (in Microsoft Access) to create a single PDF file by combining a collection of different file types (.docx, .pdf, .pptx, .jpg, .xlsx, etc)? Basically I want to loop through a windows 7 directory and create a PDF file of everything in it. I can do it manually right now by just selecting them all and right-clicking to use the menu option, but it sure would be nice to automate.
Thank you for any help -
Dan
