| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
IWshRuntimeLibrary.WshShell.SpecialFolders requires a variant argument
This was hard to debug.
Dim bulb as new IWshRuntimeLibrary.WshShell dim str as string, var as variant str = "MyDocuments" var = str Debug.print bulb.SpecialFolders(str) ' prints the all users desktop Debug.print bulb.SpecialFolders(var) ' prints the My Documents folder |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Requires | Excel Discussion (Misc queries) | |||
| novice requires help with vlook up | Excel Discussion (Misc queries) | |||
| Function (array argument, range argument, string argument) vba | Excel Programming | |||
| Wshshell / VB direction question | Excel Programming | |||
| Argument can be a variant or an object | Excel Programming | |||
Threaded Mode
