All Questions
1,035 questions
0
votes
2
answers
66
views
Exporting to PDF crosses out the date from my Excel sheet
I am currently using a macro to export my excel sheet to a pdf. The current excel sheet has the date in format MM/DD/YY, however, when I export the sheet the date appears to be crossed through.
Excel
...
- 49
0
votes
0
answers
40
views
Can't save active sheet as PDF via Macro in Excel (16.94) on Mac (15.3)
I seem to have a problem with an Excel-Macro in a sheet I want to use on Windows and Mac. The problem only occurs on my Mac (MS Excel v16.94, Dutch).
It seems that the Excel-macro on my Mac cannot ...
- 1
0
votes
0
answers
36
views
ExportAsFixedFormat PDF Quality issue
I am trying to set the quality of PDF output to xlQualityMinimum so the PDF size is smaller, however when I change from xlQualityStandard to xlQualityMinimum the output PDF ignores the margins and ...
- 1
0
votes
1
answer
60
views
Why does my button to print PDF not work in Access
I have a report in Access which I've created a button for and entered the following code for on click:
Private Sub Command18_Click()
DoCmd.RunCommand acCmdPrint
End Sub
This opens up the print ...
- 1
0
votes
1
answer
64
views
VBA/macro to Limit Save As File Options
I have been searching and searching for some codes that would do what I want, and I just can't seem to find the answer.
I am creating macro-enabled templates for office use on a network server.
Not ...
- 3
2
votes
0
answers
21
views
Excel/Adobe need to take multiple hyperlinks into pdf doc
I am looking for a way to take multiple hyperlinks that lead to individual pdf docs and have all of them opened in one pdf doc rather than thousands of individual ones.
The data comes as an excel ...
- 21
0
votes
2
answers
97
views
Attaching a file that may still be in progress of saving
My situation is I convert a TIFF file to PDF file and email it out.
When I convert my TIFF I use do it manually by Ctrl+P Microsoft Print to PDF method.
I then start a macro in outlook to attach it to ...
- 11
-1
votes
1
answer
108
views
Export html content to pdf using Microsoft Edge [closed]
I have this working code that converts HTML file to pdf by printing through command line using Microsft Edge
Sub Test()
Dim fso As Object, wshShell As Object, sPath As String, sHTMLFile As String, ...
- 9,568
0
votes
0
answers
76
views
Adding header to a PDF with VBA, Field
Adding header to a PDF with VBA, Field
I have several hundred pdf files and I want to add two part header to each of them.
The text is initially coming from Excel, but in this example it is a static ...
- 1
0
votes
1
answer
76
views
Exporting a single sheet and range as multiple pages of PDF
I have written a Macro script which takes a select group of sheets in an excel file and exports them all as a single PDF document. However, there are cases where the recipient of these documents needs ...
- 25
0
votes
0
answers
233
views
VBA Macro to mail merge a word doc to pdf in bulk - adjustment to code
We have a macro that we currently use with an excel file to mail merge large volumes to word documents and pdfs.
The code works really well but we actually only need to generate pdfs not word ...
- 1
0
votes
1
answer
522
views
Strikethrough text only when printing to PDF via VBA (inconsistent issue)
I have a spreadsheet that prints to PDF with the click of a button. The relevant VBA code is shown below. This print to PDF code has functioned flawlessly for years, but out of nowhere, people are ...
0
votes
1
answer
57
views
VBA to generate a pdf on 11x17 errors out?
I'm missing something really basic here I'm sure. I have an excel file where I want to create a pdf (or print) with certain columns shown, landscape, various formattings... on an 11x17. Everything ...
- 1
0
votes
0
answers
34
views
How to setup page correctly for pdf export using vba?
I am trying to export a specific range on a worksheet as a PDF. I want a 0.5cm margin to the left and right. Apart from that, I want the width of the range to fill the rest of the width of the page ...
0
votes
0
answers
45
views
Copy PDF file in to excel file
Sub CopyAllPDFsFromFolderToExcel()
Dim folderPath As String
Dim pdfFile As String
Dim pdfFiles As Collection
Dim i As Integer
folderPath = "C:\Users\Desktop\Testtt\"
...
0
votes
1
answer
79
views
Add attachement to email with VBA
I would like to be able to compose an email and attach a pdf file to it. This pdf file is also generated by the same VBA code.
Right now, I am able to open the email application and fill in the fields ...
0
votes
0
answers
24
views
Windows vs Mac file export a PDF
Below is the code I wrote to produce a PDF file. It prints a specific sheet and not the active sheet.
Sub Save_PDF_Pay_Slip()
Sheet14.ExportAsFixedFormat xlTypePDF, _
"E:\...
0
votes
4
answers
161
views
Search the latest saved PDF file in a various folders and copy the latest one to a specific location
I need a VBA Excel macro to find the latest saved PDF file in the folders and sub folder to get the latest (Creation date and time), then that needs to copy to a specific location.
The code below ...
- 11
0
votes
1
answer
65
views
How to change PDF Print page layout in VBA code?
I am using the below VBA code to PDF-print an Excel sheet and send the PDF-print in e-mail.
Sub savePDFandEmail()
Dim strPath As String, strFName As String
Dim OutApp As Object, OutMail As Object
...
0
votes
1
answer
244
views
Concatenate imported data from PDF file, that was split into multiple rows, into one row
I imported data from a PDF file into Excel.
Some of the columns have been split into two rows.
This image shows the issue and the outcome I would like.
There are over 1000 rows. (Note that some rows ...
0
votes
0
answers
60
views
Can I attach a report to an email sent from Access via CDO without the report location?
I need to change an email process we use within Access. We currently have internal customers fill out forms on Access databases sitting on a central server. When the user has completed their data ...
- 1
-1
votes
1
answer
153
views
VBA macro to set password to pdf files [closed]
I am trying to create multiple documents from word mail merge. Want to save them as both .docx as well as .pdf with password to open the file.
While I could successfully create word documents with ...
- 1
0
votes
0
answers
28
views
How to create a macro to automatically create (or update) PDF with preserved links? [duplicate]
I have tried to create a macro to create a PDF from my excel workbook. One sheet on the workbook has links for the other sheets. I would like to create the macro to either create (or ideally ...
0
votes
0
answers
167
views
how to attach file into pdf using console commands (shell)
I currently have a project in which I need to automate file attachment to a .pdf file using Excel VBA.
Is it possible to attach a file (.xml) to a .pdf file using only console commands or Windows ...
1
vote
1
answer
152
views
send DDE command to pdf document in SUMATRA PDF on subform
I have an MS-Access 2010 application. I use Sumatra PDF as a pdf viewer. To make the viewer fit in with the application, I have loaded the viewer on a subform, using this simple code:
Private Sub ...
- 111
0
votes
1
answer
23
views
Create a Loop & save PDF based on Specific values from another sheet
Seeking some assistance. I am not a programmer but I managed to save my PDF's by a different file name through a loop function.
I have 2 tabs that work coherently with each other. My master tab ...
user22952720
0
votes
1
answer
45
views
How to save multiple versions of the same plot with different data series as a pdf using a macro?
I would like to save multiple versions of the same plot with different data sets as a single pdf. Right now my code saves each plot individually to a separate folder (Charts in this case) based on ...
- 13
0
votes
0
answers
492
views
Borderless Print to PDF from Excel
I want to export an excel sheet to a PDF. I do so with the following VBA code (the comments are just some things I tried):
ThisWorkbook.Sheets(sheet).Select
'ActiveSheet.PageSetup....
0
votes
1
answer
55
views
autosave pdf copy of any spreadsheet i save
I'm a webdev so I'm no stranger to code, but I never use VBA. I wrote a macro that I thought would automatically save any .xslx as a pdf (in addition to the .xslx) in the same directory. Here's the ...
- 1
0
votes
1
answer
90
views
Combining PDF's from multiple folders using VBA
I'm facing issues in VBA where I'm trying to combine PDF's from multiple folders (5 folder paths) and when the user selects where they want to save the combined file. Upon saving the combined pdf, it ...
- 41
0
votes
1
answer
39
views
Prompt user with "Save as" option when exporting Selection of cells as PDF
I want to prompt the user with the SaveAs dialog when exporting a specific Selection of cells as a PDF. I found the method .SaveAs but I struggle to understand how to use it for a specific range of ...
- 117
0
votes
0
answers
121
views
reading pdf files in vba
I tried many ways to read pdf files in vba code which i use on word but nothing worked.txt and docx files work but not pdf.
here is my code:
Sub AutoOpen()
Dim objFSO As Object
Dim objFolder ...
0
votes
0
answers
62
views
Excel VBA optimizing PDFs and making them readable
this is my first post, don't be too hard on me.:
I am having trouble with this Excel VBA Code.:
Sub OptimierePDFFürTexterkennung()
Dim AcrobatApp As Object
Dim AVDoc As Object
Dim PDDoc As ...
-1
votes
1
answer
151
views
How to export each individual record as its own PDF?
I'm trying to export each record as its own PDF and save it to a specific file location.
The database has one table, one query, and one report. There are 217 records, so I'd like 217 pdf files.
I want ...
0
votes
0
answers
143
views
Excel VBA error 1004 on PDF export - not a path issue
I'm exporting multiple sheets to PDF with the following code:
ThisWorkbook.Sheets(Array("3rd party", "Dashboard", "BS_3rd")).Select
ActiveSheet....
0
votes
0
answers
43
views
Split word pages into pdf
#ASK
How to split word pages into pdf which output file name based on page footer
Sub SaveAsSeparatePDFs()
'Updated by Extendoffice 20180906
Dim I As Long
Dim xStr As String
Dim xPathStr ...
0
votes
0
answers
189
views
How can I programmatically erase PDF margins using Kofax Power Advanced and VBA/VB?
I have an issue with cropping several PDFs of various sizes.
In Kofax there's an option called "Remove White Margins". How can I achieve the same thing using VB/VBA?
EDIT : Here's a sample ...
- 1
0
votes
0
answers
51
views
VBA Excel problem with convertion PDF file to Excel
I would like to convert my PDF file to Excel.
I saw a good solution in this video:
https://www.youtube.com/watch?v=jeJR_v6TZOQ
but unfortunately with my code:
Option Explicit
Option Compare Text
...
- 1,496
1
vote
1
answer
444
views
Save Excel Sheet to a folder as PDF with filename based on cell value + Current Month name
I work on a sheet and I need to save it as PDF to my folder ("D:\NEWGIZA") so I recorded a simple macro linked to a control button to do that and it ok so far - but what I don't know how to ...
0
votes
0
answers
93
views
Export Word documents to PDF/A-2 using VBA
I'm acutally using a VBA macro in Word 2021 to Export the document to PDF/A-1:
ActiveDocument.ExportAsFixedFormat OutputFileName:=filename, ExportFormat:=wdExportFormatPDF, OpenAfterExport:=False, ...
0
votes
0
answers
57
views
Excel VBA - export multiple sheets into PDF with different combinations and names
Please help me - new job and I am out of my depth with this one.
So I have 8 tabs that need to be exported into PDF in a certain order and need to be named certainly.
Tab 1 - page 1 of version 1 - ...
0
votes
0
answers
83
views
Excel VBA - Print Selected Sheets to Multiple PDFs - Printing all sheets to single PDF -?
I have an Excel VBA PDF printer macro that should print each of the selected worksheets as individual PDFs. This was working as expected six months ago on a previous work machine, but now it's doing ...
- 11
0
votes
1
answer
97
views
Export PowerPoint presentation as PDF when hitting save with VBA
I have a PowerPoint presentation saved as .pptm. I want the presentation to be automatically exported to PDF whenever I save it (that is, whenever I press CTRL+S).
In the Visual Basic view, I have ...
- 3
0
votes
1
answer
1k
views
Using VBA to open a PDF file
I'm using the following code to open a specific file (of any type) from Excel:
Function OpenFile(ByRef fileFullName As String)
OpenTheFile:
ThisWorkbook.FollowHyperlink (fileFullName)
...
- 321
0
votes
0
answers
91
views
Setting 'Tagged PDF' to 'Yes' when saving a Word doc as PDF on Mac OS - is it possible in VBA
I'd like to save a Word doc as PDF on Mac. 'Tagged PDF' should be set 'Yes'. I can do this manually, but I'd like to do this in VBA. Do you have any idea how to achieve this whilst neither ...
- 11
0
votes
1
answer
235
views
VBA - Microsoft Print to PDF - Set Save As Path Same As Workbook Location
So I have an Excel VBA Macro that helps me save the workbook as a PDF...it is called like this...
Application.ActivePrinter = FindPrinter("Microsoft Print to PDF")
It will successfully open ...
- 73
0
votes
0
answers
84
views
My VBA code is converting each SELECTED sheet to a PDF but all sheets ends up in all PDF's, not individual ones [duplicate]
Below is my code, my selected sheets all get saved into different PDF's but they contain all the sheets. I want each sheet to be a separate PDF.
Sub ConvertToPDFAndHighlightTabs()
Dim ws As ...
0
votes
1
answer
157
views
PowerPoint macro that converts all PowerPoint files in the same directory to PDF all at once
I'd like to create a PowerPoint macro that converts all PowerPoint files in the same directory to PDF all at once, but it doesn't work.
My request:
Create PowerPoint macro that meets the requirements ...
- 156
0
votes
0
answers
288
views
save pdf file from web api with Access VBA
I need to support a legacy Access tool with some macros. I should send an xml as form attachment to a web api and receive a pdf.
I have no control on the other end.
When I submit the XML's created by ...
- 535
1
vote
1
answer
85
views
Save visible portion of range as a new workbook and export as PDF with the same name
I have a workbook with three tabs.
First tab is for data entry.
Second tab has formulas based on information entered on the first tab.
The third tab has all reference part numbers and source URLs for ...
