for the object variable? right after you open a workbook, it becomes the
activeworkbook.

Const Path As String = <your path
Dim WkBk As Workbook

< your code

Workbooks.Open Filename:=Path
Set WkBk = ActiveWorkbook

<your code

WkBk.Close SaveChanges:=False (or True)





"roumi" wrote:


Have a similar problem and will appreciate if you post the complete code


--
roumi
------------------------------------------------------------------------
roumi's Profile: http://www.excelforum.com/member.php...o&userid=24140
View this thread: http://www.excelforum.com/showthread...hreadid=377308