Linking between workbooks..

  • Thread starter Thread starter Lumous
  • Start date Start date
L

Lumous

Hi

I have a main directory that includes one file(MAIN SUMMARY.xls) an
many subdirectories named as project2001, project2002, project2003 etc
In every subdirectory I have one excel workbook with tw
worksheets(counting and summary).

Now, I have a macro behind command button in counting page that cop
working hours(range from A1 to A10) to summary page AND to MAI
SUMMARY.xls workbook. All these copy/paste actions needs to be don
every time when I push that command button.

I can do this if MAIN SUMMARY.xls is closed but if it is open,
receive this PasteSpecial Method of range class failed error.

Is there a way combine/link data from many workbooks to one workboo
regardless if workbook is open or not?

I tried to search an answer to this but I really couldn't find an
solution, if there is a thread about this just point that please
 
Lumous

Post the code. You should have a problem if the workbook is closed, not
when it's open (unless your code opens it).
 
Back
Top