Find a removable disk

[Mark Scholes]

Hi,
I would like to copy part of a workbook to a removable
disk. The job will be run on several machines and so the
the drive letter will be different on each machine. Is
there a way to get the drive letter in a macro.

MarkS

 

[Tim Williams]

Take a look at the FileSystemObject - it's able to work with drives
and will allow you to determine the type of each available disk
http://www.microsoft.com/technet/community/scriptcenter/dfs/scrdfs13.mspx

tim

 

[Bob Phillips]

or use the UNC address instead of the drive letter. If you don't know the
name of the server, open the Windows Explorer and
locate the file you want by opening Network Neighbourhood.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tom Ogilvy]

Think you missed the subject.