RayportingMonkey;188988 Wrote:
I need to create directory on a given user's c: when a specific workbook
is
opened and leave a windows shortcut in that new directory.

I have the code that will test to see if the directory exists and
prompts
the user for permission to create C:\Share if it doesn't exist.

What I need help with is creating a windows shortcut in C:\Share that
will
launch a specific workbook (namely the one that created the
directory).

Any help would be appreciated!

Thanks,
Ray
--
"Trying to make reports so easy... even a monkey could run ''em!"

Hello Ray,

It would be nice to know the folder's name and the workbook's name the
shortcut is to launch. I would rather give you a code example using this
information than a generic one.


--
Leith Ross

Sincerely,
Leith Ross

'The Code Cage' (http://www.thecodecage.com/)
------------------------------------------------------------------------
Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=52104