Results 1 to 6 of 6

Invalid procedure call or Argument (please help)

Threaded View

  1. #1
    Registered User
    Join Date
    05-14-2019
    Location
    Provo, Utah
    MS-Off Ver
    2013
    Posts
    26

    Angry Invalid procedure call or Argument (please help)

    I have this code that was working to export all my tabs based of their names (which are variables)
    Now i am getting an error code for "Invalid procedure call or argument"

    What needs to change?
     Sub PDFTabs()
    Dim ws As Worksheet
        For Each ws In Worksheets
    
            ws.ExportAsFixedFormat xlTypePDF, "C:\Users\Glen.Hervey\Documents\MAA Exports\" & ws.Name & ".pdf"
        Next ws
    End Sub
    Last edited by 6StringJazzer; 10-15-2019 at 12:32 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Invalid Procedure Call or Argument
    By theTaoJones in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2018, 03:23 PM
  2. Invalid procedure call or argument?
    By taylorsm in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-03-2017, 10:15 AM
  3. Invalid procedure call or argument
    By Netzqua in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-24-2016, 11:45 AM
  4. Invalid Procedure Call or Argument?
    By aloha31 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-19-2013, 08:24 PM
  5. Invalid procedure call or argument
    By krish T in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-31-2010, 10:01 AM
  6. Invalid procedure call or argument
    By mqdias in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 11-08-2007, 06:01 AM
  7. Invalid Procedure call or argument
    By T De Villiers in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2006, 10:05 AM

Tags for this Thread

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