Results 1 to 2 of 2

VBA Keeps failing. Run Time Error 1004

Threaded View

  1. #1
    Registered User
    Join Date
    08-31-2014
    Location
    London
    MS-Off Ver
    2013
    Posts
    21

    VBA Keeps failing. Run Time Error 1004

    Hi
    I have a model which is suppose to take a copy of each tab remove the formula and save down in a directory with a passport

    The model works up to a point where it generate the folder but after it keeps failing

    I have an old model with the same code and it works so I'm not sure what is so different from this one. I have done everything i believe exactly like the old file


    Attached is my word document with error message. Also attached is an example of the spreadsheet
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] I am getting error as "Run Time error '1004' Microsoft excel cannot paste the data
    By Amittapre in forum Excel Programming / VBA / Macros
    Replies: 43
    Last Post: 03-24-2017, 04:40 PM
  2. [SOLVED] Run-time error '438': - trying to delete a chart but code is failing
    By bishoposiris in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-14-2016, 07:24 PM
  3. [SOLVED] Run-time error '1004' - code failing when on a different sheet
    By bishoposiris in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-10-2016, 12:48 PM
  4. [SOLVED] Macros must be enabled code failing with Run Time Error 57121
    By leaning in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-30-2016, 11:25 AM
  5. ActiveSheet.Paste failing(Runtime error '1004')
    By sanjeevap in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-12-2013, 12:58 PM
  6. Error "run-time Error '1004': General Odbc Error
    By D4WNO77 in forum Access Tables & Databases
    Replies: 2
    Last Post: 07-16-2012, 09:55 AM
  7. Replies: 0
    Last Post: 05-14-2012, 11:59 PM

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