Open a sheet from other Excel file
Look at the code. Myrange is the seelcdted cell(s).
"SteM" wrote:
Thanks,
but after the open, how can i refer to a Cell of that sheet ?
--
SteM
"Joel" ha scritto nel messaggio
...
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
|