Open a sheet from other Excel file
 

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

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

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

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