Open Multiple Files in Excel

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???

TM1001
07-21-2003, 03:46 PM
I'm having similar problems with the "multiselect" option of "getopenfilename" with Excel v.X on my Mac running OS 10.2.6.

Since the previous post hasn't got any responses in more than 2 years, I suspect that this may not be the best place to post this problem.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum