calling a workbook from a cell reference

[Gregor]

Hi,
At the moment i have an inputbox which passes a value to a cell. This value is the pathname for a workbook. When i try to refer to either the cell or the dim name to open the workbook i am unsuccessful.

Does anyone know what to do?

 

[phantom1975]

WELCOME TO THE BOARD!

Can you post the relevent portion of your code?

 

[Gregor]

i'd rather it went directly from the inputbox but I'm not sure how to approach either!

Sub input()
Dim path$
path = InputBox("Please input path in the format 'C:blah*.xls'", Title:="Path Entry")
Worksheets(1).Range("a12").Value = path
Call getSheet
End Sub

sub getSheet()

Workbooks.Open "??what goes in here??"

Workbooks("??what goes in here").Sheets(1).Copy _
after:=Workbooks("totals.xls").Sheets(5)

end sub