+ Reply to Thread
Results 1 to 5 of 5

Populating Master File - Using Excel 2003 (with 2007 compatibility package)

  1. #1
    Registered User
    Join Date
    07-31-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Populating Master File - Using Excel 2003 (with 2007 compatibility package)

    report.bmpI am trying to use a temporary excel file to type information into, same columns every time but diferent amount of rows every time, then push a button to run a macro and popluate a master file. I have a code written that works as well as i can get it to work for excel 2010, however it does not want to work on an excel 2003 program (where I need it to run). My code also emails a copy of the data in the temporary file then wipes the temporary file clean. What I need is for this code (below) to work on excel 2003 (with the 2007 compatibility package).

    Please Login or Register  to view this content.
    an image of the temporary file is attached (the master file is set up the same way without the button and yellow directions)

    thank you for any help!!!

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    35,995

    Re: Populating Master File - Using Excel 2003 (with 2007 compatibility package)

    Personally, I would want to see a sample of the temporary file and the master file.

    I'd recommend opening the master file before you try and do any copying and pasting.

    And avoid selecting things ...

    Regards, TMS

    ---------- Post added at 11:27 PM ---------- Previous post was at 10:51 PM ----------

    Tough to test without the workbooks, but I can step through the code with some modifications.

    Please Login or Register  to view this content.


    I've just used a secondary sheet as the target of the paste.

    And note that you clear objects at the end of the code that you have not defined.

    Use Option Explicit to ensure that this cannot happen.


    Regards, TMS
    Trevor Shuttleworth - Excel Aid

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    07-31-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Populating Master File - Using Excel 2003 (with 2007 compatibility package)

    Worked Great!!! Thank you!!!

  4. #4
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    35,995

    Re: Populating Master File - Using Excel 2003 (with 2007 compatibility package)

    You're welcome. Thanks for the rep.

  5. #5
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Populating Master File - Using Excel 2003 (with 2007 compatibility package)

    @ psuie13

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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