Jay..

ctrlV is standard windows shortcut for paste.

ctrlM is a keyboard shortcut you can assign to a macro,
via Macro/Options

about the slashes..
why dont you experiment a little on monday, and if 2 slashes work then
fine. if not add a third slash...

the popup about opening depends on several security settings in the
registry. your systems administrator at work will need to help you
there.

basically your whole question is out of scope for this newsgroup anyway.
it wasnt related to programming nor was it related to excel.
if anything it was related to outlook or windows.

dont expect to receive full solutions in newsgroups. you'll get pointed
in a direction...

you wanted a tip. you got it. (in fact you got a bit more)
now that you know where to look..


now it's up to you!






keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


jay dean wrote:



I tried what you suggested on some private pc just because I am not
on
the network right now. I still have some questions.

1. When I try your suggestion and e-mail the file to myself and
double-click on it -- A File Download dialog box pops up which gives
an
option to open the file. Is there a way to bypass this File Download
dialog box, or add some macro which automatically chooses "open" on
the File Dialog box?
** All I want is for my e-mail recipients to be able to click on the
e-mail link and "boom" -- the Excel file opens up!

2. Also, I noticed that on the file:///c:/test.xls
link in the e-mail you used (3 slashes). Does it mean that whatever
network path I use as a link in my actual e-mail will be of the form
file:///server/share/path/document (3 slashes before server) and NOT
file://server/share/path/document (2 slashes before server)?

3. Thirdly, what are the exact steps involved in the creation of the
shortcuts Ctrl+V (in outlook) and Ctrl+M (in Excel)?

I am still not very experieced in programming and I would appreciate
your clear explanation of these for me. Thanks.

Jay Dean


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!