Sometimes the easiest tasks are the hardest to automate. The simple act of opening a file, for example, can trip up a macro, because it's not always possible to know the status of the file in advance. Is it password-protected? Has it been reserved by someone else on the network? Does the file even exist? This month, we'll look at a dozen file handling tasks, and see how macros can perform those tasks safely and effectively in both the Windows and DOS versions of 1-2-3. Throughout the macro examples, you will notice the characters 'x{ESC}'. Typing any character, then pressing Esc, clears the text after the 'file-open' and 'name-of-file' prompts- a necessary step before entering the path and file name in these macros.
展开▼