It should also be noted that I received my monthly update from microsoft yesterday or the other day I think. That is my normal process that I have been doing from almost a year or two now without any problem.
EXCEL MACRO TO PRINT TO PDF PDF
my usually process is to highlight/select the sheet/cells I want to convert into PDF which is these case includes the images and then hit the CTRL+S and choose the "save as Adobe PDF" just below the "Save As" option in excel and then from the PDF creation option I choose the following:Ģ. However, I also want the code to pull the subfolder name (01, 02, 03 and so on) and include it as part of the prefix. Both the prefix and suffix will come from data inputted in two separate cells (A2, B2). Dim str As String strC:Test ThisWorkbook.ExportAsFixedFormat xlTypePDF, str & ReportA &.
I received the update last week if I remember it right, but prior to that I have no problem or what so ever when making PDF file from EXCEL. I want to automatically rename these files by adding a prefix and suffix to the existing filename. Sub CreatePDF() Excel VBA to create PDF files. Then, the Visual Basic Editor will open up. Step-01: Go to the Developer Tab > Visual Basic Option. Going back to my concern, I'm using the latest version of Acrobat DC version 8 Here, we will print the following data range by declaring this range, and then we will save the PDF named after the value in cell F3. I use a data validation drop down list to choose the entity. I'm not sure if this person really is a representative of Adobe, but the fact that his profile is new and he is using a 3rd party email provider with a different domain that from Adobe is a BIG RED FLAG. I have created a table in excel for various entities. Be careful when dealing with people in this community always make sure you are talking to an official representative of Adobe, as these kind of people would normaly offer help to you but either later extort your files from you.
Thank you, but before anything else I just want to post this here so that everyone else would be aware.
0 kommentar(er)
