Range of an Excel Sheet

I want to open a linked Excel Sheet with the appropriate range.

The excel filename / range I have is the following:

C:\Documents and
Settings\aparmar\Desktop\Book1.xslx!Sheet!R1C1:R5C2

I'm opening the following by stripping of the extra information :
C:\Documents and
Settings\aparmar\Desktop\Book1.xslx

How do I select the Range in Excel using !Sheet!R1C1:R5C2 ?

thanks,
Amrit

Command lines to open workbooks do not include specific sheets and ranges.

To open to a specific sheet and range selection you must use VBA

Name the range then add this code to Thisworkbook module of Book1.xlsx

Private Sub Workbook_Open()
Application.Goto Reference:="myrange"
End Sub


Gord Dibben MS Excel MVP

On Wed, 20 May 2009 07:39:01 -0700, Amrit
wrote:

>I want to open a linked Excel Sheet with the appropriate range.
>
>The excel filename / range I have is the following:
>
>C:\Documents and
>Settings\aparmar\Desktop\Book1.xslx!Sheet!R1C1:R5C2
>
>I'm opening the following by stripping of the extra information :
>C:\Documents and
>Settings\aparmar\Desktop\Book1.xslx
>
>How do I select the Range in Excel using !Sheet!R1C1:R5C2 ?
>
>thanks,
>Amrit