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.