Combobox rowsource

The following line:
CboCase.RowSource = "'[Computer Price calculator.xls]Case'!$A$2:$B$4"
gives an error message: "runtime error 380.Could not set the Rowsource
property. Invalid property value"

The problem does not appear if I remove the spaces from the file name and
the single quotes but it appears if I remove the spaces and leave the single
quotes in place. Does anyone know how to make it work without having to
remove the spaces from the filename?

Thanks in advance
--
Marinos Andreou
B.Sc Computer Engineering
mobile: 99-533228

Marinos,

There is absolutely no problem with spaces in the name, so it is not that.
Most likely, you think there is one space and there is actually 2 or more.
Double check the name and the number of spaces.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Marinos Andreou" <marinosa@gawab.com> wrote in message
news:%237%23uwS4PGHA.2912@tk2msftngp13.phx.gbl...
> The following line:
> CboCase.RowSource = "'[Computer Price calculator.xls]Case'!$A$2:$B$4"
> gives an error message: "runtime error 380.Could not set the Rowsource
> property. Invalid property value"
>
> The problem does not appear if I remove the spaces from the file name and
> the single quotes but it appears if I remove the spaces and leave the
single
> quotes in place. Does anyone know how to make it work without having to
> remove the spaces from the filename?
>
> Thanks in advance
> --
> Marinos Andreou
> B.Sc Computer Engineering
> mobile: 99-533228
>
>

Thank you for your answer. I was setting a cell with the range reference and
then setting the rowsource property with the value stored in the cell but
the cell was eating up the first quote. Adding another quote infront of the
range string before storing in the cell did it.

Regards

Marinos Andreou

"Bob Phillips" <bob.phillips@notheretiscali.co.uk> wrote in message
news:%23l$IXi4PGHA.5152@TK2MSFTNGP10.phx.gbl...
> Marinos,
>
> There is absolutely no problem with spaces in the name, so it is not that.
> Most likely, you think there is one space and there is actually 2 or more.
> Double check the name and the number of spaces.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Marinos Andreou" <marinosa@gawab.com> wrote in message
> news:%237%23uwS4PGHA.2912@tk2msftngp13.phx.gbl...
>> The following line:
>> CboCase.RowSource = "'[Computer Price calculator.xls]Case'!$A$2:$B$4"
>> gives an error message: "runtime error 380.Could not set the Rowsource
>> property. Invalid property value"
>>
>> The problem does not appear if I remove the spaces from the file name and
>> the single quotes but it appears if I remove the spaces and leave the
> single
>> quotes in place. Does anyone know how to make it work without having to
>> remove the spaces from the filename?
>>
>> Thanks in advance
>> --
>> Marinos Andreou
>> B.Sc Computer Engineering
>> mobile: 99-533228
>>
>>
>
>