View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
SteM SteM is offline
external usenet poster
 
Posts: 3
Default Open a sheet from other Excel file

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