[AccessD] Special Folders

Max Wanadoo max.wanadoo at gmail.com
Thu Jul 16 05:19:46 CDT 2009


Hi List,
Is there any way I can find out in code where any of the office applications
are installed?

This works if I put the path for the application in by long-hand, but how
can I find out what the path to the application is and store it to a
variable.

const conQuote as string = """

        MsgBox "The PDF file will now open to show you total Disbursements.
Please print and file this." & vbCrLf & "Please then select the matching CSV
file to decrypt and process"
        strShell = conQuote & "C:\Program Files\Adobe\Reader
8.0\Reader\AcroRd32.exe " & conQuote
        strShell = strShell & " " & conQuote & strPathPDFFile & conQuote
        RetVal = Shell(strShell, 1)

If it was a Word document I wanted to open I would be looking for somthing
like:
strDocName = "c:\mydocs\procedure.doc"
strWord = specialpathfolder("Word") '  assuming that this returned the
qualified pathname..
strshell = conquote & strword  & conquote & " " & strDocName & conquote
retval = shell(strshell,1)

Thanks
Max



More information about the AccessD mailing list