Recent content by bama

Fixed the problem. Thanks for the offer though.

Any help would be great. I thought it got fixed. But same thing is still happening. I don't understand why its just giving me error for first file, not to the second one. If I unlink the excel from access linked manger it works fine. The second file works fine with link. Very urget help...

objxl.Workbooks.Open FileName:=Trim(strfname) objxl.Application.Run "AHC_CUST" That's just typo error each is seperate line objxl.Workbooks.Open FileName:=Trim(strfname) objxl.Application.Run "AHC_CUST" I tried Declaring each object seperate still I am getting same error. Thanks.

Any help would be great. I am stuck with this issue for last two days. Thanks I am trying to update a excel sheet from access using access macro. The code works fine for second object but not for first. I am getting the error on objxl.Workbooks.Open FileName:=Trim(strfname) Note: I am...