LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.programming
JMB JMB is offline
external usenet poster
 
Posts: 2,062
Default 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







 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Moving a folder containing linked excel files? CNN Excel Discussion (Misc queries) 0 November 4th 08 03:29 PM
How to password protect a complete folder in excel daisys_dad Excel Discussion (Misc queries) 0 August 10th 06 02:29 PM
moving a file to another folder Chris Excel Programming 3 June 26th 06 01:57 PM
Moving a file from one folder to another scantor145[_11_] Excel Programming 2 June 30th 05 03:38 PM
Moving a folder asmenut Excel Programming 4 October 24th 04 10:29 PM


All times are GMT +1. The time now is 10:24 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"