How To Export Pdf Data To Excel 2011 For Mac

I am actually working on a simple macro to save the active sheet as a PDF file with a special name. The macro I have created is working but it is saving every sheets in several PDF and put the name of the sheet at the end of the file name. If you could help me it would be great, i cannot see what is the problem. Here is my macro: Sub PrintPDF() Dim wksSheet As Worksheet Dim strFile As String Set wksSheet = ActiveSheet 'strFile = Format(Now(), 'yyyymm') _ & '.pdf' strFile = 'blabla' _ & '_' _ & Format(Now(), 'yyyymm') _ & '_' _ & 'name2' _ & ' ' _ & Replace(Replace(wksSheet.Cells(1, 2).Value, ' ', '), '.' , '_') _ & '.pdf' strFile = ThisWorkbook.Path & ':' & strFile wksSheet.SaveAs Filename:=strFile, FileFormat:=xlPDF End Sub. You have discovered a bug in Excel Mac 2011 VBA!

I left “Enable 2.0 support” checked also. Find disk identifier for usb drive on mac. Leave remote to NO and CLICK OK.

Despite using your syntax of ActiveSheet.SaveAs or my preferred:- ActiveWorkbook.SaveAs Filename:=strFile, FileFormat:=xlPDF, PublishOption:=xlSheet Excel Mac 2011 VBA will always save all worksheets. If you turn on the Macro Recorder and save a sheet to PDF, it works as expected and writes out the ActiveWorkbook version to the code module. Now immediately re-run that very code that it generated and it yields a different result! I can confirm that this bug does not exist in Excel Mac 2016 and that the worksheet syntax is no longer supported. You will need to change to the workbook syntax I included above.

You can even create a chart directly in Word 2011 for Mac and PowerPoint 2011 for Mac. The data is linked to the Excel source workbook, which remains an. Zamzar, another online free PDF to Excel Converter for mac users, allows you to upload multiple PDFs (up to 100 MB) from you computer Run Adobe Acrobat DC on your mac. Go to Tool> Export PDF. Choose Spreadsheet as output, you will be able to convert PDF to Excel on Mac with Adobe.