RDH
03-05-2001, 11:22 AM
I'm trying to generate a list of multiple files to open through VBA in Excel '98 on a Mac, but can't seem to get it to work. Am using the following:
DataFiles = Application.GetOpenFilename(MultiSelect:=xlSimple)
According to the documentation, MultiSelect should be either true or false, but neither of those generate errors. The above code is accepted, but I still can't Shift-click, Command-click, or Ctrl-click to select multiple files. Any suggestions???
DataFiles = Application.GetOpenFilename(MultiSelect:=xlSimple)
According to the documentation, MultiSelect should be either true or false, but neither of those generate errors. The above code is accepted, but I still can't Shift-click, Command-click, or Ctrl-click to select multiple files. Any suggestions???