Thanks to Al, I have made some head way on placing variables in this formula.
strfile = Source
ActiveCell.FormulaR1C1 = "='" & strfile & "'!R21C4"
I adjusted my code so it will not open the source file. It made the the formula work well and a popup box come up and reqested the sheet in the given file I wanted to link. The question now is how do I get it so it just automatically goes through each sheet and links the data..
I am so close, and again thanks al you inderectly eleminate about 5 lines of code and solved a couple of other probs I had when I realized I did not need the file open.
strfile = Source
ActiveCell.FormulaR1C1 = "='" & strfile & "'!R21C4"
I adjusted my code so it will not open the source file. It made the the formula work well and a popup box come up and reqested the sheet in the given file I wanted to link. The question now is how do I get it so it just automatically goes through each sheet and links the data..
I am so close, and again thanks al you inderectly eleminate about 5 lines of code and solved a couple of other probs I had when I realized I did not need the file open.