Workbook Open

  • Thread starter Thread starter Paul Mac.
  • Start date Start date
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.
 
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
 
Back
Top