When accessing an open file, you don't use the path.

Best way is to get the name when you open it.

--
HTH

Bob Phillips

"Ken Hudson" wrote in message
...
I have the following VBA code in which I am identifying the number of rows
in
a workbook named "FileOpenNameLast." This name includes the full path of
the
workbook and, therefore, my code deosn't work. Isn't there a simple way to
refer to the workbook name in my code?

NumRowsF832 =
Workbooks(FileOpenNameLast).Name.Sheets(1).Range(" A65536").End(xlUp).Row



--
Ken Hudson