JDone
10-16-2007, 08:37 AM
I am trying to open an excel file by using an input box. I do not want to browse, just type in the path and file name. What am I doing wrong?
PathName = InputBox("enter the path and the name of an Excel file.")
Workbooks.Open fileName:=" & PathName & "
PathName = InputBox("enter the path and the name of an Excel file.")
Workbooks.Open fileName:=" & PathName & "