Req Help: A slight variation on the auto_open theme.

  • Thread starter Thread starter aah-boy
  • Start date Start date
A

aah-boy

Hi all,

I'm not having much look with this - quite honestly I may be barking
up the wrong tree, so any help would be great.

I have a default spreadsheet - ie. it auto loads from my xlstart
directory. When I dbl-click on Excel email attachments, the attached
spreadsheet loads up Excel, my default workbook and the workbook
attachment I just clicked.

My problem is this...

My default workbook has a workbook scan in the auto_open which looks
for certains text strings in a given cell range - I need to scan the
workbook which was attached to the email message not the workbook
which has the auto_open code in it.

How do I get my default workbook to scan the attachment workbook when
excel is loading up? Or am I missing something fundamental here?

Hope I made myself clear.

Many thanks,
Dave
 
I think if you hide your auto-open workbook, it should work as you desire..

HTH, Greg
 
Back
Top