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!