Results 1 to 6 of 6

Thread: Copying cells from one workbook to another

Threaded View

  1. Apr 21st, 2005, 05:16 AM #1
    Alib
    Alib is offline

    Thread Starter
    New Member
    Join Date
    Apr 2005
    Location
    Suffolk, UK
    Posts
    12

    Resolved Copying cells from one workbook to another

    Ok, I have two files, one an excel spreadsheet, the other a text file. I open both in excel and want to copy cells from the text file to the spreadsheet using VBA. The code I have used is as follows:

    VB Code:
    1. Workbooks("conversion.xls").Sheets("Bintext3").Range("A1:DX64") = Workbooks("conversion.txt").Sheets(1).Range("A1:DX64")

    But nothing happens! No error is returned but then again nothing is copied - I'm guessing it must be something to do with the Workbooks property???
    Last edited by Alib; Apr 21st, 2005 at 08:41 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width