V
victorcamp
Excel 2007 always links to the original workbook when it's copied,
regardless of how it's copied!
There are no links in the original. Since the original is double-password
protected, the copy not only asks for its own two passwords, but also one
from the original. Once it's open, I find no reference to the original, even
though there's now one link to the original listed.
I need to do the copy via VBA, and I have no problem providing the
appropriate two passwords there. However, I don't know how to provide the
password for this ghostly original, since at least then I could delete the
link via VBA. The procedure now stops there, shows the hidden Excel, and
asks for a password. It never did this in Excel 2003.
I've searched everywhere I can think of and found no references to the file
name. I've tried SaveCopyAs, FileCopy, copying in Explorer, even DOS!
Help!
regardless of how it's copied!
There are no links in the original. Since the original is double-password
protected, the copy not only asks for its own two passwords, but also one
from the original. Once it's open, I find no reference to the original, even
though there's now one link to the original listed.
I need to do the copy via VBA, and I have no problem providing the
appropriate two passwords there. However, I don't know how to provide the
password for this ghostly original, since at least then I could delete the
link via VBA. The procedure now stops there, shows the hidden Excel, and
asks for a password. It never did this in Excel 2003.
I've searched everywhere I can think of and found no references to the file
name. I've tried SaveCopyAs, FileCopy, copying in Explorer, even DOS!
Help!