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!