+ Reply to Thread
Results 1 to 3 of 3

copy sheets from closed workbook

  1. #1
    Registered User
    Join Date
    09-28-2008
    Location
    turkey
    Posts
    6

    copy sheets from closed workbook

    need a vba code

    i have a main.xls file and two data file dat1.xls and dat2.xls

    mail named file have ar - br- cr- dr- er -fr sheets

    dat1 named file have ar-br-cr sheets

    dat2 named file have dr-er-fr sheets

    and all this files data source is

    colomn source a - fd
    row source 29-4000

    i want to make two commandbutton to main file first for dat1 second for dat2 file and i need a code to use at this buttons to make

    when dat1 and dat2 close

    main file user when click first button

    copy dat1 file ar sheet colomn source a - fd row source 29-4000 cells to main file ar sheet colomn source a - fd row source 29-4000 cells

    copy dat1 file br sheet colomn source a - fd row source 29-4000 cells to main file br sheet colomn source a - fd row source 29-4000 cells

    copy dat1 file cr sheet colomn source a - fd row source 29-4000 cells to main file cr sheet colomn source a - fd row source 29-4000 cells

    if this help come i can use it at the second button myself

    sheet to sheet range to range copy when data file close

    thank u for help ,

  2. #2
    Forum Contributor VBA Noob's Avatar
    Join Date
    04-25-2006
    Location
    London, England
    MS-Off Ver
    xl03 & xl 07(Jan 09)
    Posts
    11,988
    blackvba,

    Welcome to the forum.

    Please read the forum rules below and then add the link to the other excel forum you have posted this question to as per the rules

    VBA Noob
    _________________________________________


    Credo Elvem ipsum etian vivere
    _________________________________________
    A message for cross posters

    Please remember to wrap code.

    Forum Rules

    Please add to your signature if you found this link helpful. Excel links !!!

  3. #3
    Registered User
    Join Date
    09-28-2008
    Location
    turkey
    Posts
    6

    sorry but my problem didnt solve

    sorry VBA Noob but my problem didnt solve so i want solve it if it solved i dont need answers do you have any idea abouth my codes ?

+ 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. Copy Sheet to new Workbook and keep links "relative"
    By tekman in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 02-25-2008, 10:26 PM
  2. Auto copy data from one workbook into another.
    By Deep Paper Cut in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-21-2008, 10:57 AM
  3. Add multiple spreadsheets to single spreadsheet
    By tmotommyo in forum Excel General
    Replies: 5
    Last Post: 02-06-2008, 11:35 PM
  4. Copy A Range of Cells Or Sheet and Paste to A New Workbook
    By Nathan123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-21-2007, 09:24 PM
  5. Worksheet copy problem
    By Willow in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-28-2006, 09:56 AM

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