Windows Explorer Shows Names In Front Of Drive Letters

[OfficeUser]

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!

 

[Malke]

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

 

[OfficeUser]

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]

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

 

[OfficeUser]

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!

 

[throwitout]

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.

 

[Malke]

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

 

[PD43]

Malke, you missed the point of my question!

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

 

[OfficeUser]

<So your first option is correct.>

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