run-time error 5

  1. D

    Run-time error 5

    Hi, I hope someone can help. I am trying to create a command within a master document that will loop through a folder and extract values from specific cells and paste them to the master document. The folder has hundreds of individual files, all named differently, and each file has multiple...
  2. K

    RunTime Error 5

    Hi All, It seems an old question. I found so many posts regarding the same. But couldn't solve the error. I am trying to save my Active Sheet into a PDF using the following code. Initially, it worked fine. But recently it shows Run-time error 5. "Invalid Procedure Call & Argument". Please help...
  3. S

    Run-Time Error 5

    I inherited this piece of code for VBA, every time I try to run the program I end up getting a run time error 5. Previously I thought I had it debugged after putting in a pause, but that only worked for so long. I am working in excel 2013. The code is as follows: Sub FAANotice() Dim...
  4. C

    cell address and cell value

    Hi All I am trying to find the value/content in a cell address, but I run into run-time error 5. I don't know what is wrong, any ideas. My code is below: Private Sub ClaimCMB_Click() Dim Filename2 As String Dim Filename3 As String Dim FilePath2 As String Dim CSF As Workbook Dim CS As...
  5. X

    Set Object Variable inside an If/ElseIf Statement (Run-time error 5)

    This macro keeps giving me a run-time error '5'. Dim myOlApp As Object Dim MyItem As Object Set myOlApp = CreateObject("Outlook.Application") If Range("C6").Value = "June" Then MyItem = myOlApp.CreateItemFromTemplate(JuneTemplate) 'THE ERROR HIGHLIGHTS...
  6. M

    Pivot Table Data Source - External to Internal

    Hi everyone, I've been searching to find a way of changing my pivot table data source from Access file to a local excel sheet (of same file). Is that anyhow possible? When I select "Change Data Source" From PivotTable Tools / Options, it only allows me to select the second option, "Use an...
  7. M

    Run-time error 5 when creating a pivot table

    Hello, I am having problems with my VBA code. First, I can't get the selected cells to convert to number format (font in red). Second, I get run-time error 5 Invalid procedure call or argument when trying to create a pivot table (font in green). Any and all help is greatly appreciated! Sub...
  8. L

    Invalid Procedure Call or Arguement When changing Page item in Pivot table

    Please help. I have recorded vb that changes a page item in a pivot table when selecting from a combo box - similar to this video. http://www.datapigtechnologies.com/flashfiles/pivot10.html The recorded code that vb gives me works only if it's selecting the selection that was chosen when...
  9. D

    Run-time error '5': Invalid procedure call or argument

    Okay. So i am having an issue with my macro that creates pivot tables. Everything works fine the first time i run it but when i delete the pivot tables that were created and try to run it again i receive the error "Run-time error '5': Invalid procedure call or argument" one the second line...
  10. R

    VBA Save As Macro, Returning Run-time Error 5 on other machines

    Hey, New to VBA, mostly recording macros then editing what I can. I am trying to have a macro save a file as a PDF and extract the file name from a cell within the worksheet. The code works great on my computer but when I try to use it on any other computer it Returns run-time error 5. Here...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top