Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Recursive to search the Excel/Word's Doc and open it
Message
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00300870
Message ID:
00300952
Views:
34
>Hi George,
>
>I have read the message written on 11/09/1999, and the title was "Get a collection of sub folders from a parent folder". I have get the code and execute it. But the coding is not include the AddBS(lcdriveltr). Would you please send me the code of this function. Moreover, I hope you can tell me how to enhance the function to search all the WORD's DOCUEMENT and the open it one by one. Why I need to do this ? It is because I need to find out all the execel/word document files which have the password protect. And then I think if i can open all the excel/word's file, therefore i can't know that which file had password protected. Is it any other way can do this. Hope you give me some assistance ?
>
>Thanks
>
Hi Dennis,

I'm not entirely certain what you're asking. If you're asking about ADDBS(), it's a function in VFP 6.0 and can be found in previous versions of FoxPro in the Foxtools library. Basically all, it does is add a backslash character if required. In VFP the code might look like:
FUNCTION AddBS

LPARAMETER tPath

LOCAL lcresult
lcresult = ALLTRIM(tPath)
IF RIGHT(lcresult, 1) # '\'
  lcresult = lcresult + '\'
ENDIF
RETURN lcresult
ENDFUNC
Does this answer your question?
George

Ubi caritas et amor, deus ibi est
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform