feed mutiple files from a master source

[CharlieZangel]

I have a masterfile (Ecompiled) and would like to feed data from it into two or three other files. (For the purpose of this lets just say the two other files are "Items" & "Customer" ). I have attached a simpler sample of my files. I know there must be a way to do this with vba but i dont know too much about vba and I am hoping someone out there would be able to help. Thanks in advance of your help

[JBeaucaire]

This is not dynamic (realtime?), right? So you just need a macro to "update" the Items and the Customer files doing a straight copy/paste?

Assuming:
1) The eCompiled sheet always has all the data that should ever appear in the other workbooks
2) Each time the update occurs, the update replaces all the data in the other workbooks with the data from the eCompiled wb
3) All 3 workbooks reside in the same folder on the server
4) The Items and Customer files may or may not be open already when the macro runs

Try this:

Please Login or Register  to view this content.

This macro will open the files if they are not open already, leave them open if they were open.

[CharlieZangel]

Thanks JBeaucaire for your quick response, I really appreciate it.

I tried that on the sample file I sent you but it didnt work, It cleared all the content in the two other files.

i didnt want to trouble anyone with the actual file was why i used a simpler one, since the actual file in my opinion is a bit cumbersome but here are my actual files, master file (DATA RECORD), and feed files (CONTROLRECORD, INSUREDRECORD and POLICYRECORD)

As you will see all the information that will be needed in the feed files are all in the master file, the feed files will usually not be open, but I like the fact that you coded it to be able to run with or without them being opened.

Your assumptions are all correct

Assuming:
1) The eCompiled sheet always has all the data that should ever appear in the other workbooks YES
2) Each time the update occurs, the update replaces all the data in the other workbooks with the data from the eCompiled wb YES
3) All 3 workbooks reside in the same folder on the server YES
4) The Items and Customer files may or may not be open already when the macro runs YES

[CharlieZangel]

Hey JBeaucaire, I actually was able to get this to work must have made a mistake the first time. One thing though, when i run the macro, if all workbooks are opened I am able to populate the workbooks from the master, if they are not opened, the only one that is populated is the first file refernced in the macro. My file is attached

[JBeaucaire]

1) One of the edits you made removed some of the flexibility of the original macro. If all 4 files reside in the same folder together, the fPATH variable allows you to open the books that are closed without having to hardcode the path into the macro like you did. Change your:

Please Login or Register  to view this content.

...to

Please Login or Register  to view this content.

2) After making the edits above, make sure all 4 files are in the same folder and try again. The code is the same for all 3 workbooks except for the columns you're copying

3) In the original example, we included a key set of beginning columns in both copy commands. The sample files in post #3 lead me to believe you may want more than just the adjacent columns I now see in the macro. Look at my original example again if you want to include, perhaps, column A along with H:P.

[CharlieZangel]

Thanks for your expert help, I really appreciate this. I have made the chnges above and all the files are located in the same folder but yet only the first file referenced in the Macro is populated when I run the macro.

[JBeaucaire]

Hmm, try this:

Please Login or Register  to view this content.

[CharlieZangel]

Thanks al lot! It worked! Thanks a million!

[JBeaucaire]

If that takes care of your need, please select Thread Tools from menu above and set this topic to SOLVED.