![]() |
Windows Scripting Host/Windows XP
I have been using a small piece of code found on the newsgroup to create a
shortcut to an excel file. This has worked fine until we started upgrading to Windows XP. It works fine on stand alone machines, but hangs up on the "Save" line on our networked machines. The network administrator will give me access to the security password if it can be written into code, but I do not even know where to begin. If anyone can assist me or knows a workaround, I would greatly appreciate your help. Below is the code I am using. Thanks for your help. Valerie 'Creates Shortcut to file Set WshShell = CreateObject("Wscript.Shell") strDesktop = WshShell.SpecialFolders("Desktop") Set OShellLink = WshShell.CreateShortcut(strDesktop & "\Daily Sales " & Range("a1").Text & ".lnk") With OShellLink .TargetPath = ActiveWorkbook.FullName .WindowStyle = 4 .Save End With |
All times are GMT +1. The time now is 01:53 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com