Copy Select Columns from closed workbook into active workbook

[3345james]

From my active workbook I want to:

Get a template from a closed workbook located at C:\Users\Jim\Documents \Templates\Monthly-Template.xlsx
Copy Columns H-J or if easier Range H1:J150
It should paste to the active workbook in the same range col H1

[Mumps1]

Try:

Please Login or Register  to view this content.

Change the sheet names to suit your needs.

[3345james]

Thanks Mumps1
I'm getting a debug error on the .Sheets line
I thought perhaps the first "Sheet1" was looking for the name of the sheet in the template file so inserted "Transportation Report by Mode" the second "Sheet1" I took as needing the destination worksheet so put "TripTransProvCount.rpt"

Still no joy - any suggestions

With ActiveWorkbook
.Sheets("Sheet1").Range("H1:J150").Copy wkbDest.Sheets("Sheet1").Range("H1")
.Close False

[Mumps1]

When I tested the macro on two dummy files, it worked properly. It would be easier to test if I could see your actual files. Could you post copies of your two file?

[3345james]

Not sure how to add a files mid thread

[Mumps1]

Click the "Reply to Thread" button. Next scroll down to find the "Manage Attachments" button and click it. A window will open up with an "Add Files" button. Then you will see a "Brouse" button. Click it and the rest should be easy to understand.

[3345james]

Thanks attached

[Mumps1]

Try this macro in a regular module in the "TripTransProvCount-Sep15b.xlsx" workbook.

Please Login or Register  to view this content.

I tested the macro and it worked properly.

[3345james]

Thanks for your help - and patience! It still highlights the same line for me.
I did find a code I used long ago - combersome but works -

Please Login or Register  to view this content.

I'll close the post so as not to take up your time. I really appreciate you going the extra mile in helping.

[Mumps1]

It's funny how it worked for me but not for you but I'm glad you got something that worked for you.