Hi,

I have a workbook named empinfo (c:\desktop\empinfo.xlsm), in sheet1 it has emp details

I have a new workbook named worksystem, where sheet1 is login page, i need to open n chk emp id pwd from empinfo workbook, and activates sheet2 in worksystem

In sheet2, i have a vba code to update details in empinfo workbook.

How to open and close the empinfo workbook in common?

Because i m getting an error as "excel is waiting for another app to complete an ole action"