Solved: workbook referencing another workbook

[drawworkhome]

hi all,
in my code i copy my workbook to creaty a copy in a folder somewhere.
when i try and shut down the original workbook, i get a message stating that excel cannot shutdown this workbook because another workbook is referenced to it. this occures even if i have no other workbook open. any suggestions as to where to start looking?
thanks.
erik

[GTO]

Hi Erik,

Could you post a sample wb or the code?

Mark

[drawworkhome]

will do.
give me a few, i need to strip some stuff from it first.
thx!

[Paul_Hossler]

Erik --



in my code i copy my workbook to creaty a copy in a folder somewhere.


By 'Copy', do you mean 'FileSaveAs' with a slightly different name in a different folder?

Paul



Paul

[drawworkhome]

here it is.

[drawworkhome]

Erik --



By 'Copy', do you mean 'FileSaveAs' with a slightly different name in a different folder?

Paul



Paul
i do have that in my code at one point.

[drawworkhome]

paul, gto, the filesaveas code is in the jobsetup form code.

[drawworkhome]

hey folks, i think i figured it out.
i had set a reference "vbaproject" and i unchecked it and problem goes away. thoughts?