Thanks, Malke, for the quick response and for the explanation!

So, the following line of code opens the Stock Inventory.xls workbook in
Excel.
Workbooks.Open("C:\Stock Inventory\Stock Inventory.xls")
Will that line of code succed or fail by not putting the IBM_Preload volume
name in front of C?


"Malke" <malke@invalid.invalid> wrote in message
news:uPGJdw$dIHA.5348@TK2MSFTNGP03.phx.gbl...
> OfficeUser wrote:
>
>> When Windows Explorer is opened, the following appears under My Computer:
>> IBM_Preload (C:)
>> My Book(F:)
>>
>> What is IBM_Preload and My Book? Where do they come from? I have never
>> seen this before.
>>
>> If I program Excel to open the file C:\Customers\Contacts.xls or
>> F:\Sales.xls, will they open since I did not hardcode IBM_Preload or My
>> Book into the path?
>
> Those are the volume names. All IBM Thinkpads (and possibly other IBM
> Windows computers) name the C:\ drive IBM_Preload.
>
> You should never hardcode volume names because in all probability the
> volume
> names will be different on most computers. Then when your code is run it
> will fail.
>
> Perhaps I'm misunderstanding what you mean by "program", however. If
> you're
> just talking about opening files living on C:\ or F:\ then you're fine.
> The
> volume name has nothing to do with the location (C: or F:).
>
> Malke
> --
> MS-MVP
> Elephant Boy Computers
> www.elephantboycomputers.com
> Don't Panic!