When opening a file in Excel I use this
Workbooks.open.filename:=_ "C:\dir\dir\free.xls". DOes anyone know how to have this name look at an actual cell address on a common page???
Printable View
When opening a file in Excel I use this
Workbooks.open.filename:=_ "C:\dir\dir\free.xls". DOes anyone know how to have this name look at an actual cell address on a common page???
in vba it's:
Code:msgbox range("A1").value
------------------
david
Teenage Programmer