Merging info weekly

[Supermanjohnno]

Hey guys, I have a relativly simple problem for you that i hope you can help.
To start i have no idea how to use visual basic editor, so having a bunch of code is pretty much usless unless you can tell me what to do with it...
My problem is that i have a master workbook that i want to be able to update weekly from 5 separate workbooks with a macro. As different sections update their workbooks daily, I want to be able to draw all their info into my workbook weekly for briefing purposes. I have set up the sheets identically so merging the info will be streamlined. Obviously each of the sections' workbooks will have different content however i will contain all of the sections' content in my master workbook. attached is the filenames of all the workbooks.

Thanks for your help!

[Saarang84]

Looks like some of your workbooks are password-protected, check and see if the VBA code available in this link can be of any help for your requirement :
Erlandsen Data Consulting - ADO / DAO

[k64]

So, I can't really try this out because your workbooks are password protected, but try this:

Please Login or Register  to view this content.

(You'll have to change the file path. This just does one workbook. To do the others, just copy the code and change the path to the correct one for the next file)

How to run macros

[Supermanjohnno]

Hey thanks for helping, iam however now getting the error, "invalid outside procedure" and the 'Set' is highlighted.. hopefully i edited the code correctly
Set ThisWB = ThisWorkbook
Sheets.Add.Name = "Temp"
With Workbooks.Open("H:\My Documents\Quantity tracked items tool\COMPLETE\RHQQTICOMP+.xls")
With Sheets(1)
Intersect(.UsedRange, .UsedRange.Offset(2)).Copy ThisWB.Sheets(1).Range("A50000").End(xlUp).Offset(1)
End With
.Close False
End With



cheers

[k64]

Put your code in

Please Login or Register  to view this content.

. It's unnecessary. Lastly, I have two ideas for fixing your error. 1st, make sure that your code is in a new module, not on a specific sheet. 2nd, you could try ActiveWorkbook instead of ThisWorkbook. Let me know fi that helps it.

[Supermanjohnno]

Hey bud, still struggling.. if i unprotect the sheets can you have a go?
obviously the master file is what i need the other ones to feed into.

thanks in advance

[k64]

It works for me. All I did was change it to the correct file path for my computer.

Please Login or Register  to view this content.