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?

Thanks!

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!

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!

OfficeUser wrote:

> 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?

Once more time: the name of the volume/drive has nothing to do with its real
location. It's a human identification, not a machine identification.

Are you talking about writing a program in some programming language? If so,
you need to use the correct variables for that language. For example, in a
simple script you might use %systemdrive% instead of C:\. You should check
with a programmers' newsgroup for whatever programming language you're
writing in. This isn't a Windows XP issue.

Malke
--
MS-MVP
Elephant Boy Computers
www.elephantboycomputers.com
Don't Panic!

Malke, you missed the point of my question!

When I write the VBA code in Excel to open the workbook, Stock
Inventory.xls, which of the below is correct?
Workbooks.Open("C:\Stock Inventory\Stock Inventory.xls")
Or
Workbooks.Open("IBM_Preload (C:)\Stock Inventory\Stock Inventory.xls")

Note that the second line of code includes the Volume name.

Thanks!



"Malke" <malke@invalid.invalid> wrote in message
news:e7WsREBeIHA.4704@TK2MSFTNGP03.phx.gbl...
> OfficeUser wrote:
>
>> 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?
>
> Once more time: the name of the volume/drive has nothing to do with its
> real
> location. It's a human identification, not a machine identification.
>
> Are you talking about writing a program in some programming language? If
> so,
> you need to use the correct variables for that language. For example, in a
> simple script you might use %systemdrive% instead of C:\. You should check
> with a programmers' newsgroup for whatever programming language you're
> writing in. This isn't a Windows XP issue.
>
> Malke
> --
> MS-MVP
> Elephant Boy Computers
> www.elephantboycomputers.com
> Don't Panic!

On Feb 26, 11:18 am, "OfficeUser" <u...@Invalid.com> wrote:

> > Once more time: the name of the volume/drive has nothing to do with its
> > real
> > location. It's a human identification, not a machine identification.
>
> > Are you talking about writing a program in some programming language? If
> > so,
> > you need to use the correct variables for that language. For example, in a
> > simple script you might use %systemdrive% instead of C:\. You should check
> > with a programmers' newsgroup for whatever programming language you're
> > writing in. This isn't a Windows XP issue.

> Malke, you missed the point of my question!
>
> When I write the VBA code in Excel to open the workbook, Stock
> Inventory.xls, which of the below is correct?
> Workbooks.Open("C:\Stock Inventory\Stock Inventory.xls")
> Or
> Workbooks.Open("IBM_Preload (C:)\Stock Inventory\Stock Inventory.xls")
>
> Note that the second line of code includes the Volume name.
>
> Thanks!

You missed the answer to the question. The "IBM_Preload" is only for
human purposes, the machine doesn't actually care what the volume name
is (since it can also change!)

So your first option is correct.

OfficeUser wrote:

> Malke, you missed the point of my question!
>
> When I write the VBA code in Excel to open the workbook, Stock
> Inventory.xls, which of the below is correct?
> Workbooks.Open("C:\Stock Inventory\Stock Inventory.xls")
> Or
> Workbooks.Open("IBM_Preload (C:)\Stock Inventory\Stock Inventory.xls")
>
> Note that the second line of code includes the Volume name.

No, I didn't miss your point. I told you that you should post your question
in a newsgroup devoted to whatever programming language you are using. That
apparently is Visual Basic. Find a Visual Basic group in the list below and
post your question there:

http://aumha.org/nntp.htm - list of MS newsgroups

I'm not a programmer. This is a programming question. EOT for me because I
don't have anything further to add.

Malke
--
MS-MVP
Elephant Boy Computers
www.elephantboycomputers.com
Don't Panic!

"OfficeUser" <user@Invalid.com> wrote:

>Malke, you missed the point of my question!

HIS point - a valid one - was to ask your question elsewhere, not
here.

<So your first option is correct.>

Thank you! That's the answer I was looking for.



"throwitout" <throwitout@dodgeit.com> wrote in message
news:cb58260e-243d-4886-804b-47b42bd99f99@h25g2000hsf.googlegroups.com...
> On Feb 26, 11:18 am, "OfficeUser" <u...@Invalid.com> wrote:
>
>> > Once more time: the name of the volume/drive has nothing to do with its
>> > real
>> > location. It's a human identification, not a machine identification.
>>
>> > Are you talking about writing a program in some programming language?
>> > If
>> > so,
>> > you need to use the correct variables for that language. For example,
>> > in a
>> > simple script you might use %systemdrive% instead of C:\. You should
>> > check
>> > with a programmers' newsgroup for whatever programming language you're
>> > writing in. This isn't a Windows XP issue.
>
>> Malke, you missed the point of my question!
>>
>> When I write the VBA code in Excel to open the workbook, Stock
>> Inventory.xls, which of the below is correct?
>> Workbooks.Open("C:\Stock Inventory\Stock Inventory.xls")
>> Or
>> Workbooks.Open("IBM_Preload (C:)\Stock Inventory\Stock Inventory.xls")
>>
>> Note that the second line of code includes the Volume name.
>>
>> Thanks!
>
> You missed the answer to the question. The "IBM_Preload" is only for
> human purposes, the machine doesn't actually care what the volume name
> is (since it can also change!)
>
> So your first option is correct.