When Run iLogic rule got pop up box: Excel is already open

[Anonymous]

Could somebody help me with this problem:

I have an assembly that send and pull info from a Excel file called PF-Skeleton.xls

I have a pop up box every single time: After I filled info into a Form that I want to be transfered to that external spreadsheet and then read info back

The pop up box says:

PF-Skeleton.xls is already open. Reopening will cause any changes you made to be discarded. Do you want to reopen PF-Skeleton.xls?

I have verified if the file is open and is not, but have noticed that in the windows task manager the process indicates excel is there at least twice.

Have any of you had this behaviour in any of your models? and Why that could be happening?

Any help on this would be really appreciated,

Eric

[VdVeek · Accepted solution]

What if you close Excel after you made the changes. The error say's that you try to reopen the excel file, so there is already an excel active. Use Excel.Close. Otherwise past your ilogic code here so we can have a loo at it.

Rob.

[Anonymous · Accepted solution]

Thank you Rob,

Just had to add the excel.close to every part where the rule was used and now it works fine.

Thank you,

Eric