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...

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...

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...

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...

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...

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...

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...

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...

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...

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...