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