In Access, copy Sheet1 from Source.xls over Sheet1 in Target.xls

Posted on 2009-02-10
Last Modified: 2013-11-27
The code below coppies certain range.

wsModel.Range("A1:Z500").Copy Destination:=ws.Range("A1:Z500")

Question: How can I change it to copy the entire Sheet1 (from wsModel to/over ws)?

Note: Both wsModel and ws have Sheet1 on them.

Thank you.
Question by:Mike Eghtebas
    LVL 74

    Accepted Solution


    wsModel.Range("A1:IV65536").Copy Destination:=ws.Range("A1:IV65536")
    For Access 2003 and lower.

    wsModel.Range("A1:IXFD1048576").Copy Destination:=ws.Range("A1:XDF1048576")
    For Excel 2007.

    LVL 74

    Expert Comment

    by:Jeffrey Coachman


    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    In the previous article, Using a Critera Form to Filter Records (, the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
    In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now