Open a sheet from other Excel file
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" wrote:
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
--
SteM
|