Home |
Search |
Today's Posts |
#6
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Yes, I can see where that would be a problem. Good to know - Thanks!
"NickHK" wrote: Just that I'm not a fan of the FSO. If Sys Admin has disabled Scripting, then the FSO will not work, as it is part of the Scripting Runtime. NickHK "JMB" wrote in message ... I've not worked with them very much, but could getting the drive letter also be accomplished with a FileSystemObject and VBA's Drives Collection DriveType Property IsReady Property to test for the existence of the folder on the CD and copying it (or move on to test the next CD-ROM if the folder is not found)? Is there an advantage the API has over using these? Thanks! "NickHK" wrote: Greg, You can get the CD drive letter with : http://vbnet.mvps.org/code/disk/cdexists.htm Moving the folder can be achieved with the File System Object and MoveFolder or the API route with http://vbnet.mvps.org/code/shell/shdirectorycopy.htm NickHK wrote in message ... Hi all, How is it possible to move a complete folder from a cd. The thing I cant understand is people have different drive letters for their cd-rom etc. So is it possible to have it check the drive letter and then save the directory from the cd to the c:\21Legs Thanks for any advise Greg |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Moving a folder containing linked excel files? | Excel Discussion (Misc queries) | |||
How to password protect a complete folder in excel | Excel Discussion (Misc queries) | |||
moving a file to another folder | Excel Programming | |||
Moving a file from one folder to another | Excel Programming | |||
Moving a folder | Excel Programming |