Results 1 to 5 of 5

Help with copy text from one workbook to another.

Threaded View

  1. #1
    Registered User
    Join Date
    03-23-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    37

    Help with copy text from one workbook to another.

    Here is what I came up with using the macro recorder. The Report Template.xlsm is the sheet containing the macro.
    'Open File
        ChDir _
            "N:\Projects\_General Office\Invoices\Invoice Files"
        Workbooks.Open Filename:= _
            "N:\Projects\_General Office\Invoices\Invoice Files.xlsx" _
            , UpdateLinks:=0
        'Copy 
        Windows("Template for Vlookups.xlsx").Activate
        Range("B1:C3").Select
        Selection.Copy
        Windows("Report Template.xlsm").Activate
        ActiveSheet.Paste
    It opens the sheet and then just stops. Any Tips?
    Last edited by jcranst; 05-02-2012 at 08:20 AM.

Thread Information

Users Browsing this Thread

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

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