The UK's Number 1 for Microsoft Office Training

Sitemap

Bookmark page

Printable version

Course updates
due to adverse
weather conditions

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Linking Excel and pdf

	98.3 % recommend us
	More live stats...

Bookmark this page

Share this with a friend or colleague:

The UK's most regular
instructor-led training courses.

Training information:

Linking Excel and pdf

Resolved · Medium Priority · Version 2003

ReplyMon 21 Sep 2009, 10:25Delegate Christoper said...

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

For upcoming training course dates see: Pricing & availability

ReplyWed 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

Excel articles

· Database Tips from an Excel Training Course
· Say It With Ribbon
· Creating A Clearer Picture With Excel
· What Is A Sparkline And How Do They Work?
· Create Contrasting Coloured Rows In Excel

Please browse our web site to find out more about
microsoft excel training class and other Microsoft training courses.

Excel tip:

Date and time

CTRL+ SEMICOLON then SPACE then CTRL+SHIFT+ SEMICOLON

View all Excel hints and tips

Hi,

I've done something terribly wrong somewhere. I am working in a workbook with multiple worksheets. The listing of the worksheets, which is at the bottom so that I can move between worksheets, is gone. How can I get it back?

Cheers,

Dee

» Forum post: Disappearance of the worksheet listings at the bottom of the wor

Rate this page:

Currently 2.15/5
1
2
3
4
5

2.2/5 (213 votes cast)

Add to:

Follow @beststl on Twitter

© 2012 Best STL. All Rights Reserved. A Microsoft software training company. info
All prices offered for business users and exclude VAT. E&OE · Terms and Conditions