Open a sheet from other Excel file

[SteM]

Hi there,
is there a way to open, by Excel vba code, another Excel file and naviagate
in the sheets and cells ?

From which other 'language' can i navigate in the cells of a Excel file ?

Thanks

 

[Joel]

YOU CAN USE AN INPUTBOX


Sub testa()

fileToOpen = Application _
.GetOpenFilename("Excel Files (*.xls), *.xls")
If fileToOpen <> False Then
Workbooks.Open Filename:=fileToOpen
Set myRange = Application.InputBox(prompt:="Sample", Type:=8)
End If


End Sub

 

[SteM]

Thanks,
but after the open, how can i refer to a Cell of that sheet ?

 

[Joel]

Look at the code. Myrange is the seelcdted cell(s).