Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Default directory
Message
 
 
To
29/06/2010 10:19:43
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP SP2
Miscellaneous
Thread ID:
01470939
Message ID:
01470941
Views:
46
I bet you are using macro substitution when it's not necessary.
The Name expression will work much better
SET DEFAULT TO (cDirectoryName)
* or
CD (cDirectoryName)
>
>I created a few folders which must contain costumers' Excel's files.
>
>For example:
>
>D:\COSTUMERS\PETER\SENT
>D:\COSTUMERS\JOHN\SENT
>D:\COSTUMERS\BILLY THE KID\SENT
>
>I chose a client and I want to open one of the Excel files. I use "GETFILE()" function. If I don't set the folder as default the function forces the user to browse every time he wants to open that file.
>
>When I "SET DEFAULT TO" any of the two first examples I love myself for my intelligence... But when I "SET DEFAULT TO" the third one I hit my head against the table...
>
>I guess the blank spaces among "Billy the kid" is the problem. I don't know why "MD Billy the kid" works and "DIRECTORY("BILLY THE KID") too but not "SET DEFAULT".
>
> I know I can solve this with STRTRAN(cDirectoryName," ","_") but perhaps any of you knows another more honourable solution.
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform