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