Set wbBook = Workbooks("C:\Temp\Charts_ChgAll2.xls")

for the above code to work,file Charts_ChgAll2.xls has to be opened
when running the macro , and also code should be.

Set wbBook = Workbooks("Charts_ChgAll2.xls")

make sure that file Charts_ChgAll2.xls, is kept opened before running
the macro


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=382769