| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I can not open excel sheet by pressing file icon | Excel Discussion (Misc queries) | |||
| how can I open an excel file everytime on certain sheet? | Excel Discussion (Misc queries) | |||
| Lookup on a sheet so that every time when file open it copes data from another file sheet | Excel Programming | |||
| open new microsoft excel sheet and found my last same file all ti. | Excel Worksheet Functions | |||
| I need a shortcut to make a excel file open to a specific sheet | Excel Discussion (Misc queries) | |||
Linear Mode
