Hi,
Is there anyway in Vba that I can find and copy sheets. My idea is that I have a work with 4 sheets each is labelled differently to match a file. I.e.
Sheet Total GVA is held in drive /???/ and is called Total_GVA_20110303.xls
Sheet Single GVA is held in drive /???/ and is called single_zero_GVA_20110303.xls
and so on for all 4. The only change is the date at the end of the files
Is there anyway that I can get it to find these, open and copy in my workbook under each sheet
Is there anyway in Vba that I can find and copy sheets. My idea is that I have a work with 4 sheets each is labelled differently to match a file. I.e.
Sheet Total GVA is held in drive /???/ and is called Total_GVA_20110303.xls
Sheet Single GVA is held in drive /???/ and is called single_zero_GVA_20110303.xls
and so on for all 4. The only change is the date at the end of the files
Is there anyway that I can get it to find these, open and copy in my workbook under each sheet
