Workbook Open

P

Paul Mac.

Hi All,

Quick question I have, for anyone to help me, you can.

I would like to open a workbook programatically, using
Workbook.Open, but have a problem where the workbook has
a Workbook_open event. I am trying to compile a report,
which attaches a HTM page to an email, if the page
doesn't exist then it has to create the page from an xls
file.

Firstly, I only need to access a single worksheet within
the WB, so is it possible to select a range
without "opening" the file? The Selected range is then
passed to a HTML generator.

Secondly, If the first is not possible, can I disable the
workbook_open event? So I can the complete the conversion
and close the file.

The main reason why I would like access the single
worksheet is that the WB is abouyt 4Mb and congests the
network (slow server)

Any help would be appreciated.

Paul.
 
P

Paul Falla

Dear Paul

It is possible to access a range in another workbook
without it being open. You will need to include the
network path before the range - it will look something
like this: C:\Documents and Settings\hio1
\Desktop\[Book3.xls]Sheet1'!A1:M50

Hope this helps

Paul Falla
 
Top