VBA, Combine PDFs into one PDF file

You need to have adobe acrobat installed / operational. I used this resource re method references https://wwwimages2.adobe.com/content/dam/acom/en/devnet/acrobat/pdfs/iac_api_reference.pdf EDIT: Swapping the array for auto generated (mostly, the primary pdf still set by user) list of pathways to pdfs that you want to insert into the primary pdf) You can use something like below to generate the … Read more

How to save semi-colon delimited csv file using VBA?

i’ve just checked this because had same problem. Filename has no functionality in this case. This is what worked for me: With ActiveWorkbook .SaveAs Filename:=”My File.csv”, FileFormat:=xlCSV, Local:=True .Close False End With In regional settings -> ; <- as list separator. It is also important not to save changes when closing -> with Close you … Read more