Results 1 to 9 of 9

DeBug error

Threaded View

Turtle1219 DeBug error 08-22-2018, 11:51 AM
bakerman2 Re: DeBug error 08-22-2018, 12:17 PM
Turtle1219 Re: DeBug error 08-22-2018, 01:34 PM
bakerman2 Re: DeBug error 08-22-2018, 04:45 PM
Turtle1219 Re: DeBug error 08-23-2018, 07:45 AM
dominicb Re: DeBug error 08-23-2018, 10:20 AM
Turtle1219 Re: DeBug error 08-23-2018, 12:22 PM
bakerman2 Re: DeBug error 08-24-2018, 05:33 AM
Turtle1219 Re: DeBug error 08-24-2018, 11:33 AM
  1. #1
    Registered User
    Join Date
    08-22-2018
    Location
    Grand Rapids, MI
    MS-Off Ver
    2010
    Posts
    5

    Question DeBug error

    I have a Macro created but I am having issues with a string and cannot figure out what is the issue. My hope is that this string will export the 2 files listed( EE QA Form and TP QA Form) into a single PDF with the reps name listed in the title ( Range D9)...and if it can also include the date and time of the call being used which is in cell G13 and H13. Each time it is used it should create a new PDF file every time it is ran.

    What am I missing??



    Dim ref As String
     Dim filename1 As String
    
    Path = "T:\Consolidated_Call_Center_Reporting\Quality Reports\QA Forms\PDF\_"
     Sheets(Array("EE QA Form", "TP QA Form")).Select
         ActiveSheet.ExportAsFixedFormat Type:=xlTypePDF, filename:="T:\Consolidated_Call_Center_Reporting\Quality Reports\QA Forms\PDF\_ " & Range("D9").Text _
          & ".pdf", openafterpublish:=False, ignoreprintareas:=False
         
                
        
         MsgBox "All PDF's have been successfully exported."


    ~Thank you for any help!
    Last edited by dominicb; 08-23-2018 at 10:17 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. debug error
    By speedstr in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-19-2018, 07:08 PM
  2. Debug Error
    By cartica in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-09-2015, 09:23 PM
  3. VBA Code Runs in Debug Mode But Returns Type Mismatch Error Outside Debug Mode
    By valerie.k.chiang in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-24-2014, 03:48 PM
  4. debug error
    By VBisgreat in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-21-2012, 02:12 PM
  5. if Then = debug error
    By garretonufer in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 09-23-2009, 04:00 PM
  6. Debug error 13
    By BillGoodman in forum Excel Programming / VBA / Macros
    Replies: 30
    Last Post: 06-23-2009, 03:12 PM
  7. Error Won't Debug
    By Trip in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-29-2006, 03:10 PM

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