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

How to create Excel file using OpenXML without creating a local file?

You could use the overload of SpreadsheetDocument.Create that takes a Stream and pass it a MemoryStream: MemoryStream memoryStream = new MemoryStream(); SpreadsheetDocument spreadsheetDocument = SpreadsheetDocument.Create(memoryStream, SpreadsheetDocumentType.Workbook); //add the excel contents… //reset the position to the start of the stream memoryStream.Seek(0, SeekOrigin.Begin); return new FileStreamResult(memoryStream, “application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”); Note that as per this StackOverflow question you don’t need … Read more