macro command {CHOOSE-FILE} Russ Bartoli 24.Jul.11 04:30 PM a Web browser 1-2-3 9.7Windows XP
should be implemented.
Here is the online help for it:
{CHOOSE-FILE [file-type];results-range;[title];[x];[y]} displays a Windows common dialog box that contains a list of files and waits for the user to select one.
Arguments
file-type is text that specifies the type of files displayed in the dialog box. 1-2-3 displays the names of files in the current directory, though the user can change the path.
file-type 1-2-3 lists
worksheet Only 1-2-3 worksheet files; default if you omit the argument
all All the files in the directory
text Only text files with .TXT and .PRN extensions
You can also use the wildcard characters * (asterisk) and ? (question mark) in file-type to display a list of files with similar names or extensions.
· The * wildcard character represents any number of consecutive characters in a file name or extension. For example, to have {CHOOSE-FILE} list all files with the extension .WK4, make file-type "*.wk4".
· The ? wildcard character represents any single character in a file name or extension. For example, to have {CHOOSE-FILE} list all files with a three-character extension that begins with .W, make file-type "*.w??".
results-range is the name or address of a cell where, if the user chooses OK, 1-2-3 stores the name of the file that the user selected. If the user chooses Cancel in the dialog box, results-range is blank.
title is text that appears in the title bar of the dialog box.
x is a value that specifies the horizontal position, in pixels, measured from the left side of the screen to the left side of the dialog box.
y is a value that specifies the vertical position, in pixels, measured from the top of the screen to the top of the dialog box.
If you omit x and y, the dialog box appears in the center of the screen.
Notes
If your macros currently contain the SmartPak command {CHOOSEFILE}, this command will continue to work correctly.
File names appear in a list box.
The macro commands that follow {CHOOSE-FILE} can perform an action based on the selected file.
Return to top
. . macro command {CHOOSE-FILE} (Russ Bartoli 24.Jul.11) 
Print this page
