PDA

View Full Version : Open Excel from Word



ktmark
04-24-2007, 06:41 AM
How do I open or linkto an Excel workbook from a writeprotected Word-dokument? Is it possible?
Mark

lucas
04-24-2007, 07:36 AM
Hi Mark,
could you be a little more specific? Do you just wish to open excel alongside of word or do you wish to do something with the workbook when you open it?

ktmark
04-25-2007, 10:20 PM
Hi
Thanks for your efforts! I want a link in a Word-dokument that takes me to a specific Excel-workbook (beside the Word-doc). That is no problem, but I need to make the Word-doc protected so that the user can only write to certain fields (controls?). And when I do that, the link also becomes protected :dunno .
Mark

Zephid15
05-02-2007, 07:39 AM
this would be useful to me aswell. does anyone have an answer?
Dave

lucas
05-02-2007, 08:06 AM
It's for Excel but it should work from word too...
http://vbaexpress.com/kb/getarticle.php?kb_id=905

Zephid15
05-02-2007, 08:50 AM
Works really well. cool!

Thanks,
Dave

lucas
05-02-2007, 10:06 AM
a few examples using a protected document....doc file was also write protected at test time: