Re: Combobox rowsource

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@xxxxxxxxx> wrote in message
news:%237%23uwS4PGHA.2912@xxxxxxxxxxxxxxxxxxxxxxx
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




.

Relevant Pages

  • Combobox rowsource
    ... gives an error message: "runtime error 380.Could not set the Rowsource ... Invalid property value" ... the single quotes but it appears if I remove the spaces and leave the single ...
    (microsoft.public.excel.programming)
  • Re: datevalue
    ... "Govind" wrote: ... > Your first two values were within single quotes and hence they wont ... On the third format, am not sure of the reason why it doesnt work, ... >> When I try to use the function DateValue, I keep getting an error message of ...
    (microsoft.public.excel.worksheet.functions)
  • Re: Default XML Receive pipeline
    ... I get this error message: ... This is only when I receive an XML message with this XML Declaration: ... The XML Disassembler component doesn't like it when the "encoding" attribute ... of the declaration is wrapped in single quotes as opposed to double ...
    (microsoft.public.biztalk.general)
  • Re: $ in csh
    ... one of the parameters that I'm passing is a home directory of a tandem ... but when I try to do it with csh, I still get an error message (the ... How about single quotes instead of double quotes, ...
    (comp.unix.programmer)
  • Re: $ in csh
    ... but when I try to do it with csh, I still get an error message (the ... A NonStop system with a C-Shell?? ... Don't use C-Shell for scripting... ... How about single quotes instead of double quotes, ...
    (comp.unix.programmer)
Quantcast