Consulting

Results 1 to 3 of 3

Thread: Solved: How to get the path to special folder for MRU?

  1. #1
    VBAX Regular
    Joined
    Aug 2007
    Posts
    66
    Location

    Solved: How to get the path to special folder for MRU?

    Hello.
    I used foreign OS (not English). And I need to get the path to special folder "Recent" which located here:
    C:\Documents and Settings\kokin\Application Data\Microsoft\Office\russian_name_folder\.
    In English OS this folder be called as "Recent". And I used follow macro:
    [VBA]Sub getSpecFolder()
    Dim myPath As String
    myPath = Environ$("appdata") & "\" & "\Microsoft\Office\Recent\"
    With Dialogs(wdDialogFileOpen)
    .Name = myPath
    If .Display = -1 Then
    MsgBox .Name
    End If
    End With
    End Sub [/VBA]
    However into foreign version OS (not English) is open parent folder instead of desired.
    Question: How to get the path to special folder which has the most recent files into premises path? We can't know surely previosly how to name this folder in differents OS.
    Thank you very much.

  2. #2
    VBAX Master TonyJollans's Avatar
    Joined
    May 2004
    Location
    Norfolk, England
    Posts
    2,291
    Location
    I've just posted a reply about getting this from the registry using Word and now I see that you have a different problem with it.

    Are you saying that your registry key says the file is called "Recent" and actually it's called something else (in Russian)?

    What OS are you running, and what language version? And what language version of Office (2003) are you running?
    Enjoy,
    Tony

    ---------------------------------------------------------------
    Give a man a fish and he'll eat for a day.
    Teach him how to fish and he'll sit in a boat and drink beer all day.

    I'm (slowly) building my own site: www.WordArticles.com

  3. #3
    VBAX Regular
    Joined
    Aug 2007
    Posts
    66
    Location
    Thank you very much for your answer and help. I use Russian Windows XP and Office 2003 and 2007. The folder of recent files in Russian version called on other, not "Recent". But this method very good worked.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •