98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking Excel and pdf
Linking Excel and pdf
Resolved · Medium Priority · Version 2003
Mon 21 Sep 2009, 10:25Delegate Christoper said...
Christoper has attended:
Excel VBA Intro Intermediate course
Access VBA course
Excel VBA Advanced course
Linking Excel and pdf
Hi,
I have writen some code that generates a pdf from an Excel file and the pdf is saved in a folder. I was wondering if there is some code that would then open the pdf. I was thinking it may be in the "shell" function?
Many thanks
Chris
Wed 23 Sep 2009, 10:11Trainer Stephen said...
RE: 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
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Moving between split pane sections in a spreadsheetIf you have used the split panes feature in your worksheet, use the following keyboard shortcut keys to move quickly and effortlessly between paned sections: |
