Linking Excel and pdf

Hi Chris

Thanks for your question

You can use the shell command to open an application programmatically

For example the following line of code opens Word

Shell ("D:\Program Files\Microsoft Office\Office12\winword.exe")

The trick would be to get it to then open a specific file. I can see no arguments in the switch function to specify a particular file. It might be possible using some more general VB6 code. This will require further research on my part.

If I can find a simple solution to the problem, I will follow up this post within the next day or so

Regards

Stephen