Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
i want all windows in one excel frame (windows in taskbar) | Excel Discussion (Misc queries) | |||
cannot open exel from windows xp in windows vista and visa versa | New Users to Excel | |||
can windows vista edit shared document from windows xp | Excel Worksheet Functions | |||
Page breaks are different in Windows 2000 and Windows XP | Excel Discussion (Misc queries) | |||
Use Windows Script to run Windows Explorer Search? | Excel Programming |