Quantum Monte Carlo And Molecular Fragmentation Methods For The Treatment Of Electron Correlation In Molecules And Solids