I have an Excel macro whihc creates an Excel file and saves it to the
current directory, but I also need it to create a shortcut to the file in
another directory and give it a specific fielname. How can I do this?
Ralph - 31 Aug 2007 18:03 GMT
> I have an Excel macro whihc creates an Excel file and saves it to the
> current directory, but I also need it to create a shortcut to the file in
> another directory and give it a specific fielname. How can I do this?
See if this helps
http://www.windowsdevcenter.com/pub/a/windows/2004/04/13/VB_Shortcuts.html
-ralph
Ralph - 31 Aug 2007 18:30 GMT
> I have an Excel macro whihc creates an Excel file and saves it to the
> current directory, but I also need it to create a shortcut to the file in
> another directory and give it a specific fielname. How can I do this?
http://www.mrexcel.com/archive2/1000/1073.htm