+ Reply to Thread
Results 1 to 3 of 3

Macro than only works in my computer

  1. #1
    Registered User
    Join Date
    12-04-2013
    Location
    Barcelona
    MS-Off Ver
    Excel 2003
    Posts
    6

    Macro than only works in my computer

    Good afternoon,

    I'm a beginner in this world and I have a big problem with a macro.

    The problem is that this macro (that works to consolidate multiple files) only works in my computer.
    If I trie to run it in other computer the macro doesn't works and give's me a "1004 error".

    Could you explain me why it happens? And how can correct this? I need to use the macro in other computers.

    Thank you very much!!

    Jacobo
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    05-29-2013
    Location
    MD
    MS-Off Ver
    Excel 365
    Posts
    148

    Re: Macro than only works in my computer

    Hola, Jacobo!

    Error 1004 is related to the selection method of the range class. In 'Cristiano', this would be the lines of code that are selecting and copying/pasting data...

    Unfortunately, as the macro is built to work with specific files (i.e. yours), and this makes it hard to diagnose exactly what's going on.

    Please give us a description of the differences between the two computers. Are they both running the same OS? The same version of Excel?

    Also, on what line does the code execution stop?

    If you need to, you can request that this thread be moved to the Non-English Excel forum, donde te puedo atender en un perfecto castellano.

    Thanks and regards
    Duncan

  3. #3
    Registered User
    Join Date
    12-04-2013
    Location
    Barcelona
    MS-Off Ver
    Excel 2003
    Posts
    6

    Re: Macro than only works in my computer

    Thank you Duncan!

    I'll post my question in the Non English forum.
    For sure it's easier for me to understand the problem.

    Thanks!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VLookup works in my computer, but not in another user computer.
    By shiva_reshs in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-09-2013, 04:41 PM
  2. a dll works only on my computer ?!
    By granbapt in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-15-2012, 08:22 AM
  3. Macro works on one computer but not another
    By rockhunter in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-26-2011, 04:21 PM
  4. EDATE formula works on one computer, not on another
    By lsutiger in forum Excel General
    Replies: 2
    Last Post: 08-12-2010, 08:32 PM
  5. Formula works on one computer but not another
    By realniceguy5000 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-12-2009, 04:05 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