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

**psuie13** · 08-02-2012, 05:17 PM

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!!!

**TMS** · 08-02-2012, 06:27 PM

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

**psuie13** · 08-06-2012, 10:00 AM

Worked Great!!! Thank you!!!

**TMS** · 08-06-2012, 10:06 AM

You're welcome. Thanks for the rep.

**Cutter** · 08-06-2012, 11:40 AM

@ 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.