ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Moving Complete Folder (https://www.excelbanter.com/excel-programming/380798-moving-complete-folder.html)

No Name

Moving Complete Folder
 
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


NickHK

Moving Complete Folder
 
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




No Name

Moving Complete Folder
 
Thanks for the help Nick will look into it

Thanks

Greg

"NickHK" wrote in message
...
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




JMB

Moving Complete Folder
 
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





NickHK

Moving Complete Folder
 
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







JMB

Moving Complete Folder
 
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









All times are GMT +1. The time now is 04:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com