Thanks for any help.
I want to open Acrobat Reader from an Excel macro, with a filename in the
command line. I can open Reader, but the filename in the command line has got
me.
Here's what I use to open:
x = Shell("C:\Program Files\Adobe\Acrobat 7.0\Reader\AcroRd32.exe",
vbNormalNoFocus)
I used DDE before to open files:
channel = DDEInitiate("acroview", "control")
For a = 1 To 4
DDEExecute channel, "[DocOpen(""" & Pathname(a + 2) & File(a + 2) & """)]"
AppActivate (x)
Application.SendKeys "^a", True
Application.SendKeys "^c", True
....etc
But I think I can open with filename in the command line.
Any ideas?
Thanks