Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default VBA prob-GetOpenFilename with multiselect=true returns string

I need a GetOpenFilename function with MultiSelect=True to return a
array with the selected files' paths (wich is the correct behavior o
the function).
But, sometimes it returns just a string with the first selected fil
path.
This seems to happen when another wksheet in the same folder as the on
selected with the function is already open. I'm using Excel 97.
This is really getting on my nerves... Thanks for the help

--
Message posted from http://www.ExcelForum.com

  #2   Report Post  
Posted to microsoft.public.excel.programming
PF PF is offline
external usenet poster
 
Posts: 8
Default VBA prob-GetOpenFilename with multiselect=true returns string

I am having the same problem. Excel does not return an array if a single
file is selected. Also, for some users only 1 file is returned even when the
user selects multiple files. We are running on Excel 2003.

"felze84 " wrote:

I need a GetOpenFilename function with MultiSelect=True to return an
array with the selected files' paths (wich is the correct behavior of
the function).
But, sometimes it returns just a string with the first selected file
path.
This seems to happen when another wksheet in the same folder as the one
selected with the function is already open. I'm using Excel 97.
This is really getting on my nerves... Thanks for the help!


---
Message posted from http://www.ExcelForum.com/


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
=IF(test,true,false) only ever returns "true"? TagTech Excel Worksheet Functions 5 December 10th 08 03:04 PM
An if statment tat returns a true blank D Excel Worksheet Functions 4 August 29th 07 02:48 PM
Code returns TRUE instead of value loren.pottinger Excel Discussion (Misc queries) 2 September 5th 06 05:21 PM
GetOpenFilename returns a string rather than an array Dan Frederick Excel Programming 0 April 20th 04 08:38 PM
GetOpenFilename returns a string rather than an array Claritech Excel Programming 0 April 20th 04 06:08 PM


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"