The information in this article applies to:
SUMMARYThe Excel error message "Cannot find 'filename'" will be returned if an invalid folder is specified within a SAVE.AS() statement on a macro sheet. The use of a colon within a document name may also result in this error message because the colon is a reserved character used to specify folder paths in the Macintosh system. MORE INFORMATION
A colon cannot be typed into a filename within the Save As dialog box.
Colons are allowable characters, however, in a SAVE.AS() macro
statement, allowing a file to be saved to a particular folder
(directory). For example, =SAVE.AS("Hard Disk:Samples:Test") will save
the current document as 'Test' to the 'Samples' folder on a hard drive
labeled 'Hard Disk'.
REFERENCES
"Microsoft Excel Function Reference," version 4.0, pages 369-370
Additional query words: 2.2a 3.0a 4.00
Keywords : |
Last Reviewed: March 24, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |