need help using a text box as part of a string

[OC2]

Hi, 2 hopefully quick problems.

I am trying to open an excel spreadsheet using Access whereby the user indicates the location in a text box.

Currently my text box named test uses this string ...

" "&me!test&" "

When I add this to this function

Set myXL = getobject(, " "&me!test&" " )

I get an error message saying

cannot find C:\test\asgt.xls

Yest if I do Set myXL = getobject (, "C:\test\asgt.xls&quot

it works fine.

Any ideas?

The same thing happens when i try to do a private const

Is there something im missing here because what it cant find is actually there and it recognises it when typing only the text in.

pls help

thx

 

[ide]

Set myxl = GetObject(Me!Test)

 

[OC2]

lol, dont i feel stupid
thx for the response though