ODD Question!

[seenfresh]

This is an odd question, but I thought I would ask the world!

Is it possible to have a cell in Excell linked to a pdf file

I have the need to create a workbook with all appropriate pdf files and have certain cells in my excell book linked to those files... This would rock my world if it were possible!

Does anybody know if this is... and if so I'm guessing it would involve some sort of macro to open the pdf files, but only when I click on certain cells

Thanks in advance,

"Seen"

 

[Von Pookie]

Couldn't you just put a hyperlink to the file in the cell?

 

[seenfresh]

Ya that was dumb... I thought I needed a cell reference to hyperlink to! duh!

If I have a large PDF file that I want to link to a certain section or area within it... would this be possible?

Thanks again!

 

[Von Pookie]

You mean a certain area in the PDF file? I really have no idea, but I doubt it.

 

[patrickmuldoon99]

Is it not a possibility that you could use sendkeys to send a command to acrobat to move to a specific location?

So,

1) Setup hyperlink to PDF document (or event driven on selection_change to launch the file through shell)

2) SendKeys to the application such as Shift+Ctrl+N (Which will bring up the goto window in acrobat), then a page number, and the enter key.

I have limited experience with sendkeys however, but I feel this may possibly work...

 

[seenfresh]

Thanks Patrick I found a site:

http://cwashington.netreach.net/main/library/sendkeys.html

That describes sendkey.dll

I haven't had much change to fully read it, but if you have a chance check it out and let me know if this is along the same lines as what I am trying to accomplish... will let you know what happens!

Thanks for your advice

Sean

 

[Greg Truby]

Uh, I'd be real skittish 'bout that ol' SendKeys. Yeah, you can get it to work sometimes, but it's really a desparate move. It's dicey even when you're staying in Excel. Start trying to apply it across different applications and you're really running risks of impacting apps in ways you cannot foresee. Personally, I've never been desparate enough to use SendKeys across applications - with the notable exception of controlling a terminal emulation app where its screen object had a "send keys" method - but that's a very different kettle of fish...