Opening an XL file

  • Thread starter Thread starter Bazza
  • Start date Start date
B

Bazza

Right-o
This should be easy. ....

Under Win 98 / Office 97, I want to open an XL spreadsheet
There are a number of ways to do this normally and I have
no problem there. What would be really nice is to open the
file at SPECIFIC sheets of the workbook.

Essentially, I'm envisaging command thingies of the type -
c:\my documents\fred.xls : sheet3
or
c:\my documents\fred.xls : sheet22

Is there a syntax for this type of thing?
Thanks
 
Workbooks.Open FileName:="MyBook.xls"
Application.Goto reference:=ActiveWorkbook.Worksheets("Sheets1").Range("A1")


Regards
BrianB
======================================================
 
Workbooks.Open FileName:="MyBook.xls"
Application.Goto reference:=ActiveWorkbook.Worksheets("Sheets1").Range("A1")
Click to expand...
Say what ?

I'm not fully understanding you.
To open a file is a breeze ....
Your second line implies (if I divine your intention correctly) a
second active choice/process of selecting the particular "page".
which is selected AFTER the file has been opened.

Are you suggesting some 3rd arrangement of a VB type?
If not, would you mind expanding that explanation?

What I want to do is have an XL file (and only 1 single file of 'N'
sheets) which is displayable as a reference from a web page.

So for web page 1
you'd get to open the file X, Sheet 1
and for web page 2, file X Sheet 2 and so on

This implies a direct command line style reference to get to
the appropriate point. I could do multiple Books but I'd rather
consolidate everything into the 1 file.
 
Back
Top