+ Reply to Thread
Results 1 to 2 of 2

Mac 2011 Excel to PDF Export via Macro

  1. #1
    Registered User
    Join Date
    11-07-2014
    Location
    Durham, NC
    MS-Off Ver
    Excel: Mac 2011
    Posts
    2

    Mac 2011 Excel to PDF Export via Macro

    Hi, All -

    I have a large table and I want to run two separate macros. I am using Mac Excel 2011 and all of my users will be on a Mac.

    1 - To filter out the non zeros in the table. I have accomplished this fine and coded to a Filter button which works.

    2 - I want to then Export only the relevant rows out to an Excel PDF and place on the user's desktop. I have recorded / written the following Macro which mostly works okay on my own computer. However, when I share the document with my users and they run the same macro the formatting of the exported table is completely off, rows/columns are missing and typically the logo is missing as well. Is there a better way to update the macro?

    Also, there will be other sheets in this workbook so I only want to export the Active Sheet.

    I have attached the workbook as well.

    Sub SaveAsPDF2()
    '
    ' SaveAsPDF2 Macro
    '

    '
    Columns("A:H").Select
    Dim sPath As String
    sPath = MacScript("(path to desktop folder as string)")
    ActiveWorkbook.SaveAs Filename:= _
    sPath & ".pdf", _
    FileFormat:=xlPDF, PublishOption:=xlSelection
    Sheets("Pricing Menu").Select
    Range("A1").Select
    End Sub
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    08-31-2015
    Location
    United States
    MS-Off Ver
    Mac 2011
    Posts
    12

    Re: Mac 2011 Excel to PDF Export via Macro

    Hi,

    Try the below code

    Please Login or Register  to view this content.
    If I have helped, click on the star below the post

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Max and Min VBA macro (Excel for Mac 2011)
    By r9dro in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-01-2013, 12:55 PM
  2. Can't run a macro in Excel 2011
    By scott001 in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 1
    Last Post: 08-07-2013, 12:22 AM
  3. Replies: 2
    Last Post: 11-26-2012, 08:33 AM
  4. [SOLVED] Macro/vba to change date format from 01.01.2011 to 01/01/2011
    By Darrenh1238 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-20-2012, 07:42 PM
  5. EXCEL 2011 Mac Macro
    By johnkubik in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-09-2012, 10:14 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1