api fileopen dialog - lpstrFile size limitation?

I am using Excel to call the win api openfile dialog with the
OFN_ALLOWMULTISELECT flag set (I am selecting multiple files).

Everything works fine until I select too many files, then my function
returns nothing:-(

I have tried increasing the size of the string buffer:
udtStruct.lpstrFile = String(400#, 32)
which runs, but doesn't increase the number of files I can select. Nothing
above about 254 seems to make a difference.

Is this a limitation I am going to have to live with?

Thanks in advance,
Mike Weaver

Any reason not to use the MultiSelect parameter of the
Application.GetOpenFilename method?

Anyway, with this:

OpenFile.lpstrFile = String(25000, 0)

I got 156 files (all I selected) into an array:

Dim FileArray as Variant

FileArray = Split(OpenFile.lpstrFile, Chr(0))

--
Jim
"Mike Weaver" <mikeweaver_ak@hotmail.com> wrote in message
news:OEqRt6x3FHA.1140@tk2msftngp13.phx.gbl...
|I am using Excel to call the win api openfile dialog with the
| OFN_ALLOWMULTISELECT flag set (I am selecting multiple files).
|
| Everything works fine until I select too many files, then my function
| returns nothing:-(
|
| I have tried increasing the size of the string buffer:
| udtStruct.lpstrFile = String(400#, 32)
| which runs, but doesn't increase the number of files I can select.
Nothing
| above about 254 seems to make a difference.
|
| Is this a limitation I am going to have to live with?
|
| Thanks in advance,
| Mike Weaver
|
|

<wiping egg from face.mpeg>
Thanks, that does what I need.
[pointing object browser to application object]


"Jim Rech" <jrrech@hotmail.com> wrote in message
news:uZxDCmy3FHA.636@TK2MSFTNGP10.phx.gbl...
> Any reason not to use the MultiSelect parameter of the
> Application.GetOpenFilename method?
>
> Anyway, with this:
>
> OpenFile.lpstrFile = String(25000, 0)
>
> I got 156 files (all I selected) into an array:
>
> Dim FileArray as Variant
>
> FileArray = Split(OpenFile.lpstrFile, Chr(0))
>
> --
> Jim
> "Mike Weaver" <mikeweaver_ak@hotmail.com> wrote in message
> news:OEqRt6x3FHA.1140@tk2msftngp13.phx.gbl...
> |I am using Excel to call the win api openfile dialog with the
> | OFN_ALLOWMULTISELECT flag set (I am selecting multiple files).
> |
> | Everything works fine until I select too many files, then my function
> | returns nothing:-(
> |
> | I have tried increasing the size of the string buffer:
> | udtStruct.lpstrFile = String(400#, 32)
> | which runs, but doesn't increase the number of files I can select.
> Nothing
> | above about 254 seems to make a difference.
> |
> | Is this a limitation I am going to have to live with?
> |
> | Thanks in advance,
> | Mike Weaver
> |
> |
>
>

Any reason not to use the MultiSelect parameter of the
Application.GetOpenFilename method?

Anyway, with this:

OpenFile.lpstrFile = String(25000, 0)

I got 156 files (all I selected) into an array:

Dim FileArray as Variant

FileArray = Split(OpenFile.lpstrFile, Chr(0))

--
Jim
"Mike Weaver" <mikeweaver_ak@hotmail.com> wrote in message
news:OEqRt6x3FHA.1140@tk2msftngp13.phx.gbl...
|I am using Excel to call the win api openfile dialog with the
| OFN_ALLOWMULTISELECT flag set (I am selecting multiple files).
|
| Everything works fine until I select too many files, then my function
| returns nothing:-(
|
| I have tried increasing the size of the string buffer:
| udtStruct.lpstrFile = String(400#, 32)
| which runs, but doesn't increase the number of files I can select.
Nothing
| above about 254 seems to make a difference.
|
| Is this a limitation I am going to have to live with?
|
| Thanks in advance,
| Mike Weaver
|
|

<wiping egg from face.mpeg>
Thanks, that does what I need.
[pointing object browser to application object]


"Jim Rech" <jrrech@hotmail.com> wrote in message
news:uZxDCmy3FHA.636@TK2MSFTNGP10.phx.gbl...
> Any reason not to use the MultiSelect parameter of the
> Application.GetOpenFilename method?
>
> Anyway, with this:
>
> OpenFile.lpstrFile = String(25000, 0)
>
> I got 156 files (all I selected) into an array:
>
> Dim FileArray as Variant
>
> FileArray = Split(OpenFile.lpstrFile, Chr(0))
>
> --
> Jim
> "Mike Weaver" <mikeweaver_ak@hotmail.com> wrote in message
> news:OEqRt6x3FHA.1140@tk2msftngp13.phx.gbl...
> |I am using Excel to call the win api openfile dialog with the
> | OFN_ALLOWMULTISELECT flag set (I am selecting multiple files).
> |
> | Everything works fine until I select too many files, then my function
> | returns nothing:-(
> |
> | I have tried increasing the size of the string buffer:
> | udtStruct.lpstrFile = String(400#, 32)
> | which runs, but doesn't increase the number of files I can select.
> Nothing
> | above about 254 seems to make a difference.
> |
> | Is this a limitation I am going to have to live with?
> |
> | Thanks in advance,
> | Mike Weaver
> |
> |
>
>