Set search path from form

[CuriousGeorge]

If i want to be able to set the search path (in browse procedure) by entering the path manually from my form; how would i go on doing that?


If i, for example, want the second part of this code fragment below to be set from a text box on the form.

Shell ("C:\Users\SSS787\exjobb\Database\Readlog_update\readlog.exe C:\Users\SSS787\exjobb\Database\Readlog_update\imports\*.*")

I tried to just create a string S and set that by something like:

s=Me.TextBox.Text

and changing code above to:

Shell ("C:\Users\SSS787\exjobb\Database\Readlog_update\readlog.exe s\*.*")

but that didnt work.

Any ideas?


Thanks heaps

 

[gemma-the-husky]

somethingl ike this maybe

Shell "C:\Users\SSS787\exjobb\Database\Readlog_update\readlog.exe " & s

 

[CuriousGeorge]

thanks,


no errors are reported now but it doesnt seem to work properly.

If using nothing as path it seems as if windows is using some standard search path i.e C:\.

If, afterwards, i set the path to the folder i want it doesnt use that string as a path. It still uses the previous one.

any ideas?
cheers

 

[CuriousGeorge]

normally i have (further down in code)

.InitialFileName = C:\Users\SSS787\exjobb\Database\Readlog_update\imports\

but with .InitialFileName = s

nothing happens, doesnt seem to work at all.

(s=Me.TextPath.Text where Me.TextPath.Text shows C:\Users\SSS787\exjobb\Database\Readlog_update\imports)


Any ideas?