Thanks, I smacked my forhead and said "I shoulda had a V8" when yo
reminded me about generating the code with the macro. But, I'm no
home yet. The macro generated a single line of code.

Windows("HomeStorageInventory.xls").Visible = True
I tried this line just after the Get Object statement with
variations(see below), and all fail on "subscript out of range."

strPathXLS = "C:\Documents and Settings\CQA\M
Documents\09AdminReference\AAHomeStorage\"
strXLSSpec = strPathXLS & "HomeStorageInventory.xls"
Set InventoryBook = GetObject(strXLSSpec)
'Windows(strXLSSpec).Visible = True 'Try with full file spe
fails
'Windows(InventoryBook.Name).Visible = True 'Try with symbo
fails
Windows("HomeStorageInventory.xls").Visible = True 'Try per X
macro fails

InventoryBook does not have a "Visible" property.
So, I'm stumped.

Best regards, Lamon

--
Lamon
-----------------------------------------------------------------------
Lamont's Profile: http://www.officehelp.in/member.php?userid=502
View this thread: http://www.officehelp.in/showthread.php?t=125599

Posted from - http://www.officehelp.i