Excel Macro to Save as PDF
Automate saving Excel files as PDF using VBA macros. Plus convert those PDFs back to Excel with AnyPDF. AnyPDF uses AI to read your PDF pages and extract structured data — tables, text, and fields — into a clean spreadsheet you can download instantly.
Try it now — free during beta
Upload your PDF and get an Excel file in seconds. No signup required.
Upload PDFHow AnyPDF solves this
1
Upload your PDF
Drag and drop any PDF document. We support bank statements, invoices, receipts, reports, and more — up to 10 MB.
2
AI extracts your data
Our AI analyzes each page — detecting tables, columns, rows, and fields automatically. Works with scanned and native PDFs.
3
Download your spreadsheet
Get your data as Excel (.xlsx), CSV, TXT, or DOCX. The file is ready for use in Excel, Google Sheets, or any spreadsheet software.
Frequently asked questions
How do I create a macro to save Excel as PDF?
Use VBA: ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, Filename:="output.pdf". This saves the active sheet as PDF programmatically.
Can I convert the PDF output back to Excel?
Yes. Upload the PDF to AnyPDF to extract the data back into an editable Excel spreadsheet.