runtime error

  1. S

    RunTime Error 462 while converting word docx to PDF

    '******* EmpFolder is a Global Variable containing Folder Path ************************* Sub BatchConvertDocxToPDF() Dim objDoc1 As Document Dim strFile As String, strFolder As String 'Initialization strFolder = EmpFolder & "" strFile = Dir(strFolder & "*.docx", vbNormal)...
  2. K

    vbs script suddenly started "unknown runtime error" on running macro in excel - any ideas??

    My script was running just fine up until about a week ago. Now it throws an error on the macro run statement. The macro runs fine in the spreadsheet when run manually. We did run windows updates, and an antivirus update; but that should not have changed anything in this - right? I'm running...
  3. C

    VBA Internet Controls Macro Running Slow and Stopping at the 242nd Number In List

    I have written a macro that pulls numbers from a long list and inputs them into a website. After looping through about the 25th number, it seems to start noticeably slowing down more and more. It also seems to crash at 242 numbers and displays 'Run-time Error -2147319783: Automation Error. Old...
  4. B

    Runtime Error '1004'

    I keep getting the following error and I don't know why: Runtime Error '1004': Method range of object global Failed Here is my code with the line causing the issue denoted with the *. Sub Button1_Click()ActiveSheet.Range("AL2:AL399").Value = 0 ActiveSheet.Range("BH2:BP399").Value = ""...
  5. T

    VBA - run time error '13' type mismatch selecting sheet based on named range

    Hi everyone, Please can someone help me with the following, apologies if this is quite basic. I've not done any VBA for a long time and I'm out of practice. In my Excel workbook I have a number of buttons to take you to different sheets in the model, I'm trying to write code that can be...
  6. A

    Calling a macro when activating a sheet

    Hi all! When I activate a Sheet A, I want to run a macro which does something on another Sheet B, including copy and paste some ranges on sheet B. The macro runs well independently. However, when I put it in the event of activating Sheet A, the following error occurs: Runtime Error...
  7. I

    Runtime error Out of Memory

    Beginner VBA user here. I'm getting a runtime error that says "Out of Memory" with one certain set of code. I have one specific worksheet within a workbook that contains 4 rows each valued as the days Monday, Tuesday, Wednesday, Thursday respectively in Column "A". The nature of the worksheet...
  8. I

    Run-Time error 1004 when clearing cells

    I'm scanning ID & Username into "column A1" the vba then moves the cursor to the right to "column b" finally down to "A2,B2,etc.... But if I make an error of some sort and click on the cell to delete the ID or Username this Run-time error '1004': Application-defined or object-defined error...
  9. T

    Run-time error 2147024894

    Hello, Hoping someone can help me with this. I am attempting to run a script from Excel that saves an exported report from SAP in a given location. This code runs without issue on several computers. When I emailed the code to a coworker they kept getting this error: Run-time error '-2147024894...
  10. Rlhoffarthexcel

    Macro created in PC Excel returns Run-time error 448 when run in Mac Excel

    I have a very frustrating Macro issue: A pair of macros that were created in Excel for PC won't run properly on my Excel for Mac. And, yes, I've "enabled Macros" on my Mac whenever I pull up Excel files that have Macros. BACKGROUND: I run a MacPro, 16 gigs RAM, 1TB SSD. I run Parallels for...
  11. M

    Run time error

    Hi Folks, I am running a code that I use everyday without fault , nothing has changed but I am getting a run time error which has dwindle my motivation to fix it. here is the vba script with the error highlighted. Public Sub ROCSORT() TotalRowsROC = Worksheets("ROC").UsedRange.Rows.Count...
  12. J

    Can't add new controls to userform. Run-time error '-2147352573 (80020003)'

    Hello all, First off I'm really new to excel and vba so bare with me I've always been able to solve whatever problems I encounter, searching forum and melting my brain, but this one is way out of my reach and I don't seem to find nothing in the forums that clearly solves the problem. I'm...
  13. A

    runtime error 2110

    Still new with VBA, using only what i have learned online and on these forums lol. I have created a multipage userform in excel. i entered a code to set focus on blank text before moving on to the next page when clicking "next" however i keep getting Run-time error '2110' "Cant move focus to...
  14. X

    Run Time Error 13

    Hi, I inherited a macro & it has worked in previous months but this month I am getting the data type mismatch error. I've done some digging & understand that is telling me its an unrecognized data type but I wanted to post the code to see if anyone sees somenthin obvious...theres a ton more code...
  15. K

    For Each loop with Dim as Long - Run-time error '6' Overflow

    Hi all I'm struggling a bit with a Run-time error '6' Overflow. My code is only able to handle 32.767 cells so I assume the reason is a default Dim As Integer. If so I guees I only need to have Dim changed to Long but for some reason I can figure out how to do this in my For Each loop. And as...
  16. T

    Dynamic Range error When Multiple Workbooks Open

    In the attached spreadheet, I have a dynamic range defined which populates a dropdown https://dl.dropboxusercontent.com/u/63479593/Enterprise%20Release%20Project%20Dashboard.xlsm Dynamic Range Is =OFFSET(Projects!$C$1,1,0,COUNTIF(Projects!$C:$C,">""")-1,2) This populates a drop down in the...
  17. S

    Error 800A9C68 running VBS using task scheduler

    Hello, I keep getting this windows script host error. Script: C\top 5 macro.vbs Line: 5 Char: 1 Error: Unknown runtime error Code: 800A9C68 Source: Microsoft VBScript runtime error Dim xlApp Dim xlBook Set xlApp = CreateObject("Excel.Application") Set xlBook =...
  18. bs0d

    VBA ADO Query Run-time Error: System Resources Exceeded

    I'm running an ADO query through Excel to insert up to 50k rows into a table. The query uses dSUM to get a running total for items by date, so it's likely that it is "calculation heavy". Even running directly in Access, it takes a moment to complete. When running it in Excel however, I get the...
  19. D

    Macro error interfacing with SAP after Window 7 Update

    I've created a macro that opens SAP, and downloads a number of different reports. It was working fine last week, but after an update to Windows 7 from xp (and excel 2007 to 2010), I now receive the following error during a loop in my code: Run-time error '619' The control could not be found by...
  20. M

    SaveToFile Runtime Error -2147024891

    I'm running Access 2007 and have a table with several Excel file attachments (one attachment per record). Each record has a Type field to identify the various files. In VBA, I'm running a routine to save the Excel file to my hard drive. Here is an excerpt from my code: Set rs =...

Some videos you may like

This Week's Hot Topics

Top