| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Identifying version of Adobe Reader
Hi,
I have written some code that will open a pdf file using the following code: Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe " & File_To_Open1, vbNormalFocus This works fine if the user has the same version as me (5.0) but I found that many users in this company have different versions. Can I get the version from the Registry (and if so how)? I also thought about looking at my directories and finding the Adobe folder but thought this is an untidy method.. I got around this by capturing the error if 5.0 couldn't be found which worked until I found a version 6.0 CE. I got around this but putting the following code in: If The_Ver = "6.0" Then The_Ver = "6.0 CE" I don't want to keep having to create these get-arounds. Is there an easier way??? I am also lead to believe you don't need to put the version in but I haven't been able to get to work. Any ideas? -- Andrew |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Identifying version of Adobe Reader
Something like this?
Version = createobject("wscript.shell").regread("HKCR\AcroEx ch.App\AcrobatVersion\") "Andrew" wrote in message ... Hi, I have written some code that will open a pdf file using the following code: Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe " & File_To_Open1, vbNormalFocus This works fine if the user has the same version as me (5.0) but I found that many users in this company have different versions. Can I get the version from the Registry (and if so how)? I also thought about looking at my directories and finding the Adobe folder but thought this is an untidy method.. I got around this by capturing the error if 5.0 couldn't be found which worked until I found a version 6.0 CE. I got around this but putting the following code in: If The_Ver = "6.0" Then The_Ver = "6.0 CE" I don't want to keep having to create these get-arounds. Is there an easier way??? I am also lead to believe you don't need to put the version in but I haven't been able to get to work. Any ideas? -- Andrew |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Identifying version of Adobe Reader
Hi Zoo,
Thanks for helping but I get the following error (I have no idea what this means...) Run-time error '-2147024894 (80070002)': Invalid root in registry key 'HKCR\AcroExch.App\AcrobatVersion\". -- Andrew "Zoo" wrote: Something like this? Version = createobject("wscript.shell").regread("HKCR\AcroEx ch.App\AcrobatVersion\") "Andrew" wrote in message ... Hi, I have written some code that will open a pdf file using the following code: Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe " & File_To_Open1, vbNormalFocus This works fine if the user has the same version as me (5.0) but I found that many users in this company have different versions. Can I get the version from the Registry (and if so how)? I also thought about looking at my directories and finding the Adobe folder but thought this is an untidy method.. I got around this by capturing the error if 5.0 couldn't be found which worked until I found a version 6.0 CE. I got around this but putting the following code in: If The_Ver = "6.0" Then The_Ver = "6.0 CE" I don't want to keep having to create these get-arounds. Is there an easier way??? I am also lead to believe you don't need to put the version in but I haven't been able to get to work. Any ideas? -- Andrew |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Identifying version of Adobe Reader
How about this?
createobject("wscript.shell").regread("HKCR\AcroEx ch.Document\AcrobatVersion \") "Andrew" wrote in message ... Hi Zoo, Thanks for helping but I get the following error (I have no idea what this means...) Run-time error '-2147024894 (80070002)': Invalid root in registry key 'HKCR\AcroExch.App\AcrobatVersion\". -- Andrew "Zoo" wrote: Something like this? Version = createobject("wscript.shell").regread("HKCR\AcroEx ch.App\AcrobatVersion\") "Andrew" wrote in message ... Hi, I have written some code that will open a pdf file using the following code: Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe " & File_To_Open1, vbNormalFocus This works fine if the user has the same version as me (5.0) but I found that many users in this company have different versions. Can I get the version from the Registry (and if so how)? I also thought about looking at my directories and finding the Adobe folder but thought this is an untidy method.. I got around this by capturing the error if 5.0 couldn't be found which worked until I found a version 6.0 CE. I got around this but putting the following code in: If The_Ver = "6.0" Then The_Ver = "6.0 CE" I don't want to keep having to create these get-arounds. Is there an easier way??? I am also lead to believe you don't need to put the version in but I haven't been able to get to work. Any ideas? -- Andrew |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Identifying version of Adobe Reader
Bingo!!
Thanks mate -- Andrew "Zoo" wrote: How about this? createobject("wscript.shell").regread("HKCR\AcroEx ch.Document\AcrobatVersion \") "Andrew" wrote in message ... Hi Zoo, Thanks for helping but I get the following error (I have no idea what this means...) Run-time error '-2147024894 (80070002)': Invalid root in registry key 'HKCR\AcroExch.App\AcrobatVersion\". -- Andrew "Zoo" wrote: Something like this? Version = createobject("wscript.shell").regread("HKCR\AcroEx ch.App\AcrobatVersion\") "Andrew" wrote in message ... Hi, I have written some code that will open a pdf file using the following code: Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe " & File_To_Open1, vbNormalFocus This works fine if the user has the same version as me (5.0) but I found that many users in this company have different versions. Can I get the version from the Registry (and if so how)? I also thought about looking at my directories and finding the Adobe folder but thought this is an untidy method.. I got around this by capturing the error if 5.0 couldn't be found which worked until I found a version 6.0 CE. I got around this but putting the following code in: If The_Ver = "6.0" Then The_Ver = "6.0 CE" I don't want to keep having to create these get-arounds. Is there an easier way??? I am also lead to believe you don't need to put the version in but I haven't been able to get to work. Any ideas? -- Andrew |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Identifying version of Adobe Reader
This site may help you.(But the site is for Delphi)
http://www.vincenzo.net/isxkb/module...article&sid=73 "Andrew" wrote in message ... Hi Zoo, Thanks for helping but I get the following error (I have no idea what this means...) Run-time error '-2147024894 (80070002)': Invalid root in registry key 'HKCR\AcroExch.App\AcrobatVersion\". -- Andrew "Zoo" wrote: Something like this? Version = createobject("wscript.shell").regread("HKCR\AcroEx ch.App\AcrobatVersion\") "Andrew" wrote in message ... Hi, I have written some code that will open a pdf file using the following code: Shell "C:\Program Files\Adobe\Acrobat 5.0\Reader\AcroRd32.exe " & File_To_Open1, vbNormalFocus This works fine if the user has the same version as me (5.0) but I found that many users in this company have different versions. Can I get the version from the Registry (and if so how)? I also thought about looking at my directories and finding the Adobe folder but thought this is an untidy method.. I got around this by capturing the error if 5.0 couldn't be found which worked until I found a version 6.0 CE. I got around this but putting the following code in: If The_Ver = "6.0" Then The_Ver = "6.0 CE" I don't want to keep having to create these get-arounds. Is there an easier way??? I am also lead to believe you don't need to put the version in but I haven't been able to get to work. Any ideas? -- Andrew |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I get rid of Adobe Reader icon? | Excel Discussion (Misc queries) | |||
| Excel XLSX Chart won't Save into Adobe InDesign Version CS3 | Charts and Charting in Excel | |||
| how can you hyper link adobe reader files into excel | Excel Discussion (Misc queries) | |||
| how i can take file from adobe reader and make it read with micr. | Excel Discussion (Misc queries) | |||
| Identifying Excel version | Excel Programming | |||
Linear Mode
