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!
|
Similar Threads
