Results 1 to 28 of 28

Open new workbook, copy and paste not working

Threaded View

  1. #4
    Forum Contributor
    Join Date
    01-18-2013
    Location
    Prague, Czech rep.
    MS-Off Ver
    Excel 2003 - 2016
    Posts
    138

    Re: Open new workbook, copy and paste not working

    first thing, you got typo in the dim part....wkbto vs wbkto (dim / set)

    EDIT1: mby its just me but you got strange logic, you are copying things from the WB you´ve named TO and you´re copyíng them to list FROM, mby I´m just a bit off but its highly confusing to me

    EDIT2: if you´re trying to select all its much easier, shorter, and cleaner to use this syntax:

    cells.select
    rather than jumping end right & down (if it´s not all cells than sorry, it just seemed that it is).

    rest seems OK,

    So I believe all the problem is in the wrong declaration, than it should be working fine.

    Soul
    Last edited by SoulPrisoner; 11-18-2013 at 10:45 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Simple Open Workbook, Copy Sheet, Paste In New Workbook Question
    By alulla in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2013, 02:10 PM
  2. Open workbook, filter values, copy/paste into Active workbook.
    By niceguy21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-10-2013, 12:17 PM
  3. Copy 2 sheets from a open workbook and paste to a closed workbook
    By grimston in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-27-2012, 03:27 PM
  4. Replies: 2
    Last Post: 09-11-2012, 09:42 AM
  5. Simple task: Open a workbook, copy a range, paste into another workbook
    By fbonetti in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-21-2011, 01:12 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