mac excel vba loop : from list & then export as pdf

by

I’m not a MAC user so I may be missing some restrictions I don’t have in Windows OS, but you may be after something like follows:

Option Explicit

Sub Pdfexportmacro()

    Dim rCell As Range, rRng As Range

    'Student numbers in cells A7:A160
    Set rRng = Worksheets("studentlist").Range("A7:A160") '<--| set your "students" range

    With Worksheets("Feedback") '<--| reference "Feedback" worksheet
        For Each rCell In rRng '<--| loop through "students" range
            .Range("A1").Value = rCell.Value '<--| write current student number to cell A1 on Feedback sheet

           ' Export & save file as pdf using SNum as filename:
            .ExportAsFixedFormat Type:=xlTypePDF, fileName:= _
            "Macintosh HD:Users:Michael:Desktop:" & rCell.Value, Quality:= _
            xlQualityStandard, IncludeDocProperties:=True, IgnorePrintAreas:=False, _
            OpenAfterPublish:=False
        Next rCell
    End With

End Sub

More Related Contents:

  1. to make this code simpler
  2. VBA code takes long time to execute in excel
  3. Wait until ActiveWorkbook.RefreshAll finishes – VBA
  4. Pop up the Excel Statusbar?
  5. Excel VBA deleting rows in a for loop misses rows
  6. What is the lifetime of a global variable in excel vba?
  7. Download attachment from Outlook and Open in Excel
  8. What is the most efficient/quickest way to loop through rows in VBA (excel)?
  9. Embed picture in outlook mail body excel vba
  10. How to check for empty array in vba macro [duplicate]
  11. Excel VBA to Export Selected Sheets to PDF
  12. Use autofilter on more than 2 criteria
  13. Searching an excel with two search words (multiple lookup) using vba macro [closed]
  14. What is the function of FormulaR1C1?
  15. Compiler Error: User-defined types not defined
  16. Open a workbook using FileDialog and manipulate it in Excel VBA
  17. Vba Excel do vlookup from a closed file
  18. excel hyperlink to nothing
  19. How to add headers to a multicolumn listbox in an Excel userform using VBA
  20. How to send files via HTTP_POST with Excel using VBA?
  21. VBA to open Excel hyperlink does not work when hyperlink generated with a formula
  22. How to Add Date Picker To VBA UserForm
  23. Vba macro to copy row from table if value in table meets condition
  24. Difference between Thisworkbook.name and Activeworkbook.name in VBA
  25. How to break a long string into multiple lines
  26. Read VBA macros (or vbaProject.bin) of an Excel file without opening it in MS Excel [closed]
  27. simple vba code gives me run time error 91 object variable or with block not set
  28. How do I get a list of unique values from a range in Excel VBA?
  29. How to get selected value in multicolumn listbox
  30. Query my excel worksheet with VBA

Leave a Comment